/// <summary> /// 更新一条数据 /// </summary> public string Update(UFIDA.U8.UAP.CustomApp.ControlForm.Model._Scraps model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update _Scraps set "); if (model.GUIDHead != null) { strSql.Append("GUIDHead=N'" + model.GUIDHead + "',"); } else { strSql.Append("GUIDHead= null ,"); } if (model.Remark != null) { strSql.Append("Remark=N'" + model.Remark + "',"); } else { strSql.Append("Remark= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where iID=" + model.iID + ""); return(strSql.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model._Scraps model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.GUIDHead != null) { strSql1.Append("GUIDHead,"); strSql2.Append("N'" + model.GUIDHead.ToString() + "',"); } if (model.cCode != null) { strSql1.Append("cCode,"); strSql2.Append("N'" + model.cCode + "',"); } if (model.SerialNo != null) { strSql1.Append("SerialNo,"); strSql2.Append("N'" + model.SerialNo + "',"); } if (model.Remark != null) { strSql1.Append("Remark,"); strSql2.Append("N'" + model.Remark + "',"); } strSql.Append("insert into _Scraps("); 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 btnOK_Click(object sender, EventArgs e) { try { if (!clsUserRight.chkRight(sUserID, 8010)) { throw new Exception("没有权限"); } if (gridView1.RowCount == 0) { throw new Exception("请输入表体"); } string sErr = ""; try { gridView1.FocusedRowHandle -= 1; gridView1.FocusedRowHandle += 1; } catch { } int iCou = 0; SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { string sSerCode = txtCode.Text.Trim(); Model._Scrap model = new UFIDA.U8.UAP.CustomApp.ControlForm.Model._Scrap(); string sState = ""; string sSQL = "select * from _Scrap where cCode = N'" + txtCode.Text.Trim() + "'"; DataTable dtTemp = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dtTemp != null && dtTemp.Rows.Count > 0) { if (dtTemp.Rows[0]["AuditUserName"].ToString().Trim() != "") { throw new Exception("单据已经审核,不能保存"); } } //新增 if (txtCode.Text.Trim() == "") { sState = "add"; model.CreateUserName = sUserName; model.CreateDate = DateTime.Today; long iCode = 0; sSQL = "select max(cCode) as cCode from [_Scrap] where cCode like '111111%'"; sSQL = sSQL.Replace("111111", dtmCode.DateTime.ToString("yyMMdd")); DataTable dtCode = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dtCode == null && dtCode.Rows.Count == 0) { iCode = 1; } else { string s = dtCode.Rows[0]["cCode"].ToString().Trim(); if (s.Length > 6) { iCode = BaseFunction.ReturnLong(s.Substring(6)); } else { iCode = BaseFunction.ReturnLong(s); } iCode += 1; } string sCode = iCode.ToString().Trim(); while (sCode.Length < 4) { sCode = "0" + sCode; } sCode = dtmCode.DateTime.ToString("yyMMdd") + sCode; model.cCode = sCode; model.dDate = dtmCode.DateTime; if (lookUpEditPerson.EditValue != null) { model.Person = lookUpEditPerson.EditValue.ToString().Trim(); } if (lookUpEditDep.EditValue != null) { model.DepCode = lookUpEditDep.EditValue.ToString().Trim(); } model.Remark = txtRemark.Text.Trim(); model.CreateUserName = sUserName; model.CreateDate = DateTime.Now; DAL._Scrap dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL._Scrap(); sSQL = dal.Add(model); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } else { sState = "edit"; model.cCode = txtCode.Text.Trim(); model.dDate = dtmCode.DateTime; model.Person = lookUpEditPerson.EditValue.ToString().Trim(); model.DepCode = lookUpEditDep.EditValue.ToString().Trim(); model.Remark = txtRemark.Text.Trim(); model.CreateUserName = txtCreateUserName.Text.Trim(); model.CreateDate = dtmCreate.DateTime; DAL._Scrap dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL._Scrap(); sSQL = dal.Update(model); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } sSQL = @"update _FrockClamp set iState = 1 where SerialNo in (select SerialNo from _Scraps where cCode = N'" + txtCode.Text.Trim() + "') and isnull(Closed,'') = '' "; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = "delete _Scraps where cCode = N'" + model.cCode + "'"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); for (int i = 0; i < gridView1.RowCount; i++) { if (gridView1.GetRowCellValue(i, gridColSerialNo).ToString().Trim() != "") { Model._Scraps models = new UFIDA.U8.UAP.CustomApp.ControlForm.Model._Scraps(); models.cCode = model.cCode; models.SerialNo = gridView1.GetRowCellValue(i, gridColSerialNo).ToString().Trim(); models.Remark = gridView1.GetRowCellValue(i, gridColRemark).ToString().Trim(); DAL._Scraps dals = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL._Scraps(); sSQL = dals.Add(models); iCou = iCou + DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = "select iState from _FrockClamp where SerialNo = '111111'"; sSQL = sSQL.Replace("111111", gridView1.GetRowCellValue(i, gridColSerialNo).ToString().Trim()); dtTemp = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dtTemp != null && BaseFunction.ReturnInt(dtTemp.Rows[0]["iState"]) == 1) { sSQL = "update _FrockClamp set iState = 4,Closed = N'222222',CloseDate = getdate() where SerialNo = N'111111'"; sSQL = sSQL.Replace("111111", gridView1.GetRowCellValue(i, gridColSerialNo).ToString().Trim()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } else { sErr = sErr + "行" + (i + 1).ToString() + "工装不是可用状态\n"; continue; } } } if (sErr.Length > 0) { throw new Exception(sErr); } if (iCou > 0) { tran.Commit(); MessageBox.Show("OK\n"); this.DialogResult = DialogResult.OK; } else { throw new Exception("no data"); } } catch (Exception ee) { MessageBox.Show(ee.Message); tran.Rollback(); } } catch (Exception ee) { MessageBox.Show(ee.Message); } }