有一个功能
private void checkAndLoad()
{
string GenerateOrderNumber()
{
const string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
var random = new Random();
return new string(Enumerable.Repeat(chars, 8)
.Select(s => s[random.Next(s.Length)]).ToArray());
}
string orderNumber = GenerateOrderNumber();
if (!string.IsNullOrEmpty(orderNumber))
{
string QueryGetItogPrice1 = $"select ({Numeric.Value} * price) as itog_cena from titles where title = '{TitlesList.Text}'";
SqlCommand cmd = new SqlCommand(QueryGetItogPrice1, sqlConn);
string summa = $"{cmd.ExecuteScalar():F2}";
string QueryGetPrice = $"SELECT COALESCE(price, 0) AS ytd_sales FROM titles where title = '{TitlesList.Text}'";
SqlCommand cmd3 = new SqlCommand(QueryGetPrice, sqlConn);
string price = $"{cmd3.ExecuteScalar():F2}";
DataTable table = new DataTable();
table.Columns.Add("№ Заказа", typeof(string));
table.Columns.Add("Магазин", typeof(string));
table.Columns.Add("Издания", typeof(string));
table.Columns.Add("Кол-во", typeof(string));
table.Columns.Add("Услове оплаты", typeof(string));
table.Columns.Add("Цена", typeof(string));
table.Columns.Add("Сумма", typeof(string));
table.Rows.Add($"{orderNumber}", $"{StoresList.Text}", $"{TitlesList.Text}", Numeric.Value, Terms.Text, price, summa);
DataGridView1.DataSource = table;
}
}
要求再次调用该函数时,checkAndLoad()
内部函数不被调用GenerateOrderNumber()
。
例如将其设为字段