private void ClientWindow_Load(object sender, EventArgs e) { client1.Text = UniversalFunctions.GetInstence().GetAutoincreaseID("gzb_clients", "clientID"); client19.Text = "2015-07-16 12:00:00"; String sqlPara = "clientID,companyName,gzbID,address,contactName,tel,fax,postNumber,bankName,email,bankAccount,taxNumber,PrivateBank,mainContact,mainTel,mainPhone,beizhu,modifyName,modifyDate"; String sql = "SELECT " + sqlPara + " FROM gzb_clients WHERE gzb_account ='" + MainWindow.UserID + "'"; DataTable data = DatabaseManager.Ins.ExcuteDataTable(sql, null); List <BaseControl> basecontrols = new List <BaseControl>() { client1, client2, client3, client4, client5, client6, client7, client8, client9, client10, client11, client12, client13, client14, client15, client16, client17, client18, client19 }; UniversalFunctions.GetInstence().SetValuesByBaseControls(UniversalFunctions.GetInstence().DataTableConvertToList <String>(data).ToList(), basecontrols); }
private void clientSave_Click(object sender, EventArgs e) { if (UniversalFunctions.GetInstence().CheckIfValdated(new List <BaseControl>() { client17 })) { String sqlPara = "gzb_account,clientID,companyName,gzbID,address,contactName,tel,fax,postNumber,bankName,email,bankAccount,taxNumber,PrivateBank,mainContact,mainTel,mainPhone,beizhu,modifyName,modifyDate"; String sql = "INSERT INTO gzb_clients (" + sqlPara + ") VALUES (" + ("@" + sqlPara).Replace(",", ",@") + ");"; List <String> basecontrols = new List <String>() { MainWindow.UserID, client1.Text, client2.Text, client3.Text, client4.Text, client5.Text, client6.Text, client7.Text, client8.Text, client9.Text, client10.Text, client11.Text, client12.Text, client13.Text, client14.Text, client15.Text, client16.Text, client17.Text, client18.Text, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; List <MySqlParameter> Paramter = UniversalFunctions.GetInstence().CombineMysqlParametersByBaseControl(sqlPara.Split(',').ToList(), basecontrols); if (DatabaseManager.Ins.ExecuteNonquery(sql, Paramter.ToArray()) > 0) { XtraMessageBox.Show("成功", "保存成功!"); } } else { XtraMessageBox.Show("警告", "带(*)为必填项目!"); } }