/// <summary> /// 增加一条数据 /// </summary> public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model._CustomerFeedback model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.CustomerFeedback != null) { strSql1.Append("CustomerFeedback,"); strSql2.Append("'" + model.CustomerFeedback + "',"); } strSql.Append("insert into _CustomerFeedback("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); return(strSql.ToString()); }
private void btnSave_Click(object sender, EventArgs e) { string sErr = ""; int iCount = 0; try { try { gridView1.FocusedRowHandle -= 1; gridView1.FocusedRowHandle += 1; } catch { } SqlConnection conn = new SqlConnection(Conn); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { string sSQL = "truncate table _CustomerFeedback"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); for (int i = 0; i < gridView1.RowCount; i++) { string sCustomerFeedback = gridView1.GetRowCellValue(i, gridColCustomerFeedback).ToString().Trim(); if (sCustomerFeedback == "") { continue; } Model._CustomerFeedback mod = new UFIDA.U8.UAP.CustomApp.ControlForm.Model._CustomerFeedback(); mod.CustomerFeedback = sCustomerFeedback; DAL._CustomerFeedback dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL._CustomerFeedback(); sSQL = dal.Add(mod); iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } if (sErr != "") { throw new Exception(sErr); } if (iCount > 0) { tran.Commit(); MessageBox.Show("OK"); GetGrid(); } else { throw new Exception("no data"); } } catch (Exception ee) { tran.Rollback(); throw new Exception(ee.Message); } } catch (Exception ee) { MessageBox.Show(ee.Message); } }