/// <summary>
/// 更新一条数据
/// </summary>
public string Update(UFIDA.U8.UAP.CustomApp.ControlForm.Model._科目对照 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update _科目对照 set ");
if (model.会计科目 != null)
{
strSql.Append("会计科目='" + model.会计科目 + "',");
}
if (model.对照科目 != null)
{
strSql.Append("对照科目='" + model.对照科目 + "',");
}
if (model.Remark != null)
{
strSql.Append("Remark='" + 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._科目对照 model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.会计科目 != null)
{
strSql1.Append("会计科目,");
strSql2.Append("'" + model.会计科目 + "',");
}
if (model.对照科目 != null)
{
strSql1.Append("对照科目,");
strSql2.Append("'" + model.对照科目 + "',");
}
if (model.Remark != null)
{
strSql1.Append("Remark,");
strSql2.Append("'" + model.Remark + "',");
}
strSql.Append("insert into _科目对照(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
return(strSql.ToString());
}
private void btnSave_Click(object sender, EventArgs e)
{
string sErr = "";
int iCount = 0;
try
{
if (lookUpEditiYear.EditValue == null || lookUpEditiYear.EditValue.ToString().Trim() == "")
{
lookUpEditiYear.Focus();
throw new Exception("请选择年度");
}
try
{
gridView1.FocusedRowHandle -= 1;
gridView1.FocusedRowHandle += 1;
}
catch { }
string sSQL = "";
SqlConnection conn = new SqlConnection(Conn);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
for (int i = 0; i < gridView1.RowCount; i++)
{
bool b = BaseFunction.ReturnBool(gridView1.GetRowCellValue(i, gridColchoose));
if (!b)
{
continue;
}
Model._科目对照 model = new UFIDA.U8.UAP.CustomApp.ControlForm.Model._科目对照();
model.会计科目 = gridView1.GetRowCellValue(i, gridCol会计科目).ToString().Trim();
model.对照科目 = gridView1.GetRowCellValue(i, gridCol对照科目).ToString().Trim();
model.Remark = gridView1.GetRowCellValue(i, gridColRemark).ToString().Trim();
model.RemarkJ = gridView1.GetRowCellValue(i, gridColRemarkJ).ToString().Trim();
model.RemarkD = gridView1.GetRowCellValue(i, gridColRemarkD).ToString().Trim();
model.年度 = lookUpEditiYear.EditValue.ToString().Trim();
model.iID = BaseFunction.ReturnInt(gridView1.GetRowCellValue(i, gridColiID).ToString().Trim());
//if (model.对照科目.Trim() == "")
//{
// sErr = sErr + "行" + (i + 1).ToString() + "对照科目没有设置\n";
// continue;
//}
DAL._科目对照 dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL._科目对照();
sSQL = dal.Exists(model.年度, model.对照科目, model.iID.ToString());
DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dt.Rows.Count > 0)
{
throw new Exception("行" + (i + 1) + "对照科目不可重复");
}
if (model.iID == 0)
{
sSQL = dal.Add(model);
}
else
{
sSQL = dal.Update(model);
}
iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
}
if (sErr.Length > 0)
{
throw new Exception(sErr);
}
if (iCount > 0)
{
tran.Commit();
MessageBox.Show("OK\n");
GetGrid();
}
else
{
throw new Exception("no data");
}
}
catch (Exception ee)
{
tran.Rollback();
throw new Exception(ee.Message);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
