110,538
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnOk_Click(object sender, EventArgs e)
{
try
{
string sql = "INSERT INTO [Msg_Communication]([UserId],[CommuGroup],[UserName],[Mobile],[Email],[Address],[Tel],[Remark]) ";
int index = 0;
foreach (DataGridViewRow row in this.DgvData.Rows)
{
if (index++ != 0)
{
sql += " UNION ALL ";
}
string[] paras = new string[8];
paras[0] = CurrentUser.Id;
paras[1] = CboGroup.SelectedValue.ToString();
int i = 0;
foreach (DataGridViewColumn column in this.DgvData.Columns)
{
paras[column.DisplayIndex + 2] = row.Cells[column.Index].Value.ToString();
if (i++ >= 6)
{
break;
}
}
sql += string.Format(" SELECT '{0}',{1},'{2}','{3}','{4}','{5}','{6}','{7}'", paras);
}
PyClient.Logic.Common.SQLiteHelper.ExecuteNonQuery(DatabaseBuilder.PyClientConnectionString, DatabaseBuilder.PyClientPassword, sql);
}
catch (Exception ex)
{
MessageBox.Show("保存失败!失败原因:" + ex.Message);
}
}