public Form10(MySqlConnection conn, string user) { InitializeComponent(); this.conn = conn; this.user = user; string name = ""; //设置label1的值 conn.Open(); string sql_tip = $"SELECT TName FROM tradesman WHERE TNo = '{user}'"; MySqlCommand cmd = new MySqlCommand(sql_tip, conn); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); name = reader.GetString("TName"); reader.Close(); label1.Text = "欢迎" + name + "~"; //保鲜期到期/库存提醒 richTextBox1.AppendText("保鲜期到期/库存不足提醒(低于原保质期天数的0.2倍/库存少于100kg):\n"); richTextBox1.AppendText("农产品\t\t\t库存(kg)\t\t库存提醒\t\t保质期(day)\t\t剩余保质期(day)\n"); DateTime timeNow = System.DateTime.Now; Tradesman[] freshGroup = new Tradesman[30]; Tradesman tradesFre = null; int i = -1; //获取pno数组 string sql_deal = $"SELECT PNo,TStock FROM deal WHERE TNo = '{user}'"; cmd = new MySqlCommand(sql_deal, conn); MySqlDataReader reader1 = cmd.ExecuteReader(); while (reader1.Read()) { tradesFre = new Tradesman(); tradesFre.pno = reader1.GetString("PNo"); tradesFre.stock = reader1.GetInt32("TStock"); freshGroup[++i] = tradesFre; } reader1.Close(); //获取cno在通过全局常量crops获得cname和fresh信息 i = 0; int j; MySqlDataReader reader2 = null; string sql_getcno = ""; while (freshGroup[i] != null) { sql_getcno = $"SELECT CNo,ProdDate FROM plante WHERE PNo = '{freshGroup[i].pno}'"; cmd = new MySqlCommand(sql_getcno, conn); reader2 = cmd.ExecuteReader(); reader2.Read(); freshGroup[i].cno = reader2.GetString("CNo"); freshGroup[i].timePro = reader2.GetDateTime("ProdDate"); //获取commom.crops中值 j = 0; while (Common.crops[j] != null) { if (Common.crops[j].cno.Equals(freshGroup[i].cno)) { freshGroup[i].cname = Common.crops[j].cname; //get cname freshGroup[i].freshness = Common.crops[j].freshness; // get freshness sd = new SubDate(freshGroup[i].timePro, timeNow); freshGroup[i].leave = freshGroup[i].freshness - sd.dateSub(); //get剩余保质期 break; } j++; } if (freshGroup[i].leave <= 0) { if (freshGroup[i].stock < 100) { richTextBox1.AppendText(freshGroup[i].cname + "\t\t\t" + freshGroup[i].stock + "\t\t\t不足\t\t\t" + freshGroup[i].freshness + "\t\t\t\t已过期\n"); } else { richTextBox1.AppendText(freshGroup[i].cname + "\t\t\t" + freshGroup[i].stock + "\t\t\t充足\t\t\t" + freshGroup[i].freshness + "\t\t\t\t已过期\n"); } freshGroup[i].isFresh = 1;//过期 } else if (freshGroup[i].leave < freshGroup[i].freshness * 0.2) { if (freshGroup[i].stock < 100) { richTextBox1.AppendText(freshGroup[i].cname + "\t\t\t" + freshGroup[i].stock + "\t\t\t不足\t\t\t" + freshGroup[i].freshness + "\t\t\t\t" + freshGroup[i].leave + "\n"); } else { richTextBox1.AppendText(freshGroup[i].cname + "\t\t\t" + freshGroup[i].stock + "\t\t\t充足\t\t\t" + freshGroup[i].freshness + "\t\t\t\t" + freshGroup[i].leave + "\n"); } } else { } i++; reader2.Dispose(); } reader2.Close(); //UPDATE plante - IsFresh string sql_update = ""; i = 0; while (freshGroup[i] != null) { sql_update = $"UPDATE plante SET IsFresh = '{freshGroup[i].isFresh}' WHERE PNo = '{freshGroup[i].pno}'"; cmd = new MySqlCommand(sql_update, conn); cmd.ExecuteNonQuery(); i++; } conn.Close(); }
private void button2_Click(object sender, EventArgs e) { richTextBox1.Text = ""; richTextBox1.AppendText("仓库:\n"); richTextBox1.AppendText("生产编号\t\t农产品\t\t库存(kg)\t\t保质期(天)\t\t生产日期\n"); Tradesman[] freshGroup = new Tradesman[30]; Tradesman tradesFre = null; MySqlCommand cmd = null; int i = -1; conn.Open(); //获取pno数组 string sql_deal = $"SELECT PNo,TStock FROM deal WHERE TNo = '{user}'"; cmd = new MySqlCommand(sql_deal, conn); MySqlDataReader reader1 = cmd.ExecuteReader(); while (reader1.Read()) { tradesFre = new Tradesman(); tradesFre.pno = reader1.GetString("PNo"); tradesFre.stock = reader1.GetInt32("TStock"); freshGroup[++i] = tradesFre; } reader1.Close(); //获取cno在通过全局常量crops获得cname和fresh信息 i = 0; int j; MySqlDataReader reader2 = null; string sql_getcno = ""; while (freshGroup[i] != null) { sql_getcno = $"SELECT CNo,ProdDate FROM plante WHERE PNo = '{freshGroup[i].pno}'"; cmd = new MySqlCommand(sql_getcno, conn); reader2 = cmd.ExecuteReader(); reader2.Read(); freshGroup[i].cno = reader2.GetString("CNo"); freshGroup[i].timePro = reader2.GetDateTime("ProdDate"); //获取commom.crops中值 j = 0; while (Common.crops[j] != null) { if (Common.crops[j].cno.Equals(freshGroup[i].cno)) { freshGroup[i].cname = Common.crops[j].cname; //get cname freshGroup[i].freshness = Common.crops[j].freshness; // get freshness richTextBox1.AppendText(freshGroup[i].pno + "\t\t" + freshGroup[i].cname + "\t\t" + freshGroup[i].stock + "\t\t\t" + freshGroup[i].freshness + "\t\t\t\t" + freshGroup[i].timePro.ToLongDateString() + "\n"); break; } j++; } i++; reader2.Dispose(); } conn.Close(); reader2.Close(); }
private void button1_Click(object sender, EventArgs e) { richTextBox1.Text = ""; conn.Open(); MySqlCommand cmd = null; //保鲜期到期/库存提醒 richTextBox1.AppendText("保鲜期到期/库存不足提醒(低于原保质期天数的0.2倍/库存少于100kg):\n"); richTextBox1.AppendText("农产品\t\t\t库存(kg)\t\t库存提醒\t\t保质期(day)\t\t剩余保质期(day)\n"); DateTime timeNow = System.DateTime.Now; Tradesman[] freshGroup = new Tradesman[30]; Tradesman tradesFre = null; int i = -1; //获取pno数组 string sql_deal = $"SELECT PNo,TStock FROM deal WHERE TNo = '{user}'"; cmd = new MySqlCommand(sql_deal, conn); MySqlDataReader reader1 = cmd.ExecuteReader(); while (reader1.Read()) { tradesFre = new Tradesman(); tradesFre.pno = reader1.GetString("PNo"); tradesFre.stock = reader1.GetInt32("TStock"); freshGroup[++i] = tradesFre; } reader1.Close(); //获取cno在通过全局常量crops获得cname和fresh信息 i = 0; int j; MySqlDataReader reader2 = null; string sql_getcno = ""; while (freshGroup[i] != null) { sql_getcno = $"SELECT CNo,ProdDate FROM plante WHERE PNo = '{freshGroup[i].pno}'"; cmd = new MySqlCommand(sql_getcno, conn); reader2 = cmd.ExecuteReader(); reader2.Read(); freshGroup[i].cno = reader2.GetString("CNo"); freshGroup[i].timePro = reader2.GetDateTime("ProdDate"); //获取commom.crops中值 j = 0; while (Common.crops[j] != null) { if (Common.crops[j].cno.Equals(freshGroup[i].cno)) { freshGroup[i].cname = Common.crops[j].cname; //get cname freshGroup[i].freshness = Common.crops[j].freshness; // get freshness sd = new SubDate(freshGroup[i].timePro, timeNow); freshGroup[i].leave = freshGroup[i].freshness - sd.dateSub(); //get剩余保质期 break; } j++; } if (freshGroup[i].leave <= 0) { if (freshGroup[i].stock < 100) { richTextBox1.AppendText(freshGroup[i].cname + "\t\t\t" + freshGroup[i].stock + "\t\t\t不足\t\t\t" + freshGroup[i].freshness + "\t\t\t\t已过期\n"); } else { richTextBox1.AppendText(freshGroup[i].cname + "\t\t\t" + freshGroup[i].stock + "\t\t\t充足\t\t\t" + freshGroup[i].freshness + "\t\t\t\t已过期\n"); } freshGroup[i].isFresh = 1;//过期 } else if (freshGroup[i].leave < freshGroup[i].freshness * 0.2) { if (freshGroup[i].stock < 100) { richTextBox1.AppendText(freshGroup[i].cname + "\t\t\t" + freshGroup[i].stock + "\t\t\t不足\t\t\t" + freshGroup[i].freshness + "\t\t\t\t" + freshGroup[i].leave + "\n"); } else { richTextBox1.AppendText(freshGroup[i].cname + "\t\t\t" + freshGroup[i].stock + "\t\t\t充足\t\t\t" + freshGroup[i].freshness + "\t\t\t\t" + freshGroup[i].leave + "\n"); } } else { } i++; reader2.Dispose(); } reader2.Close(); conn.Close(); }