/// <summary>
/// 增加一条数据
/// </summary>
public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model._GiveBack model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.GUID != null)
{
strSql1.Append("GUID,");
strSql2.Append("N'" + model.GUID.ToString() + "',");
}
if (model.cCode != null)
{
strSql1.Append("cCode,");
strSql2.Append("N'" + model.cCode + "',");
}
if (model.dDate != null)
{
strSql1.Append("dDate,");
strSql2.Append("N'" + model.dDate + "',");
}
if (model.Person != null)
{
strSql1.Append("Person,");
strSql2.Append("N'" + model.Person + "',");
}
if (model.DepCode != null)
{
strSql1.Append("DepCode,");
strSql2.Append("N'" + model.DepCode + "',");
}
if (model.Remark != null)
{
strSql1.Append("Remark,");
strSql2.Append("N'" + model.Remark + "',");
}
if (model.CreateUserName != null)
{
strSql1.Append("CreateUserName,");
strSql2.Append("N'" + model.CreateUserName + "',");
}
if (model.CreateDate != null)
{
strSql1.Append("CreateDate,");
strSql2.Append("N'" + model.CreateDate + "',");
}
if (model.AuditUserName != null)
{
strSql1.Append("AuditUserName,");
strSql2.Append("N'" + model.AuditUserName + "',");
}
if (model.AuditDate != null)
{
strSql1.Append("AuditDate,");
strSql2.Append("N'" + model.AuditDate + "',");
}
strSql.Append("insert into _GiveBack(");
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());
}
/// <summary>
/// 更新一条数据
/// </summary>
public string Update(UFIDA.U8.UAP.CustomApp.ControlForm.Model._GiveBack model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update _GiveBack set ");
if (model.GUID != null)
{
strSql.Append("GUID=N'" + model.GUID + "',");
}
else
{
strSql.Append("GUID= null ,");
}
if (model.dDate != null)
{
strSql.Append("dDate=N'" + model.dDate + "',");
}
else
{
strSql.Append("dDate= null ,");
}
if (model.Person != null)
{
strSql.Append("Person=N'" + model.Person + "',");
}
else
{
strSql.Append("Person= null ,");
}
if (model.DepCode != null)
{
strSql.Append("DepCode=N'" + model.DepCode + "',");
}
else
{
strSql.Append("DepCode= null ,");
}
if (model.Remark != null)
{
strSql.Append("Remark=N'" + model.Remark + "',");
}
else
{
strSql.Append("Remark= null ,");
}
if (model.CreateUserName != null)
{
strSql.Append("CreateUserName=N'" + model.CreateUserName + "',");
}
else
{
strSql.Append("CreateUserName= null ,");
}
if (model.CreateDate != null)
{
strSql.Append("CreateDate=N'" + model.CreateDate + "',");
}
else
{
strSql.Append("CreateDate= null ,");
}
if (model.AuditUserName != null)
{
strSql.Append("AuditUserName=N'" + model.AuditUserName + "',");
}
else
{
strSql.Append("AuditUserName= null ,");
}
if (model.AuditDate != null)
{
strSql.Append("AuditDate=N'" + model.AuditDate + "',");
}
else
{
strSql.Append("AuditDate= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where cCode=" + model.cCode + "");
return(strSql.ToString());
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
if (!clsUserRight.chkRight(sUserID, 6010))
{
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._GiveBack model = new UFIDA.U8.UAP.CustomApp.ControlForm.Model._GiveBack();
string sState = "";
string sSQL = "select * from _GiveBack 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 [_GiveBack] 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._GiveBack dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL._GiveBack();
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._GiveBack dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL._GiveBack();
sSQL = dal.Update(model);
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
}
sSQL = "delete _GiveBacks 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._GiveBacks models = new UFIDA.U8.UAP.CustomApp.ControlForm.Model._GiveBacks();
models.cCode = model.cCode;
models.SerialNo = gridView1.GetRowCellValue(i, gridColSerialNo).ToString().Trim();
models.Remark = gridView1.GetRowCellValue(i, gridColRemark).ToString().Trim();
models.RequisitionsiID = BaseFunction.ReturnInt(gridView1.GetRowCellValue(i, gridColRequisitionsiID));
sSQL = @"
select * from _FrockClamp where SerialNo = N'111111'
";
sSQL = sSQL.Replace("111111", models.SerialNo);
DataTable dtTemp2 = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
long lTimes = BaseFunction.ReturnLong(dtTemp2.Rows[0]["Times"]);
if (lTimes > 0)
{
long lTimesNow = BaseFunction.ReturnLong(gridView1.GetRowCellValue(i, gridColTimes));
if (lTimesNow <= 0)
{
sErr = sErr + "行" + (i + 1).ToString() + "请输入使用次数";
continue;
}
models.Times = lTimesNow;
}
DAL._GiveBacks dals = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL._GiveBacks();
sSQL = dals.Add(models);
iCou = iCou + DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = "select iState from _FrockClamp where SerialNo = N'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"]) == 2)
{
sSQL = "update _FrockClamp set iState = 1 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)
{
tran.Rollback();
throw new Exception(ee.Message);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
