private string StrWhere() { string strWhere = string.Empty; Boolean bOn = ClsDataAuth.GetAuth(canshu.u8Login.cUserId); if (!bOn) { strWhere = strWhere + string.Format(" and (a.xzr like '%{0}/%' or a.xmgly='{0}' or a.fzr='{0}' )", canshu.u8Login.cUserId); } return(strWhere); }
public void QiShen() { //校验是否有审核权限 Boolean bOn = ClsDataAuth.GetAuth(canshu.u8Login.cUserId); if (!bOn) { MessageBox.Show("没有弃审权限!"); return; } try { gridView1.CloseEditor(); string str = ""; int j = 0; for (int i = 0; i < dtMo.Rows.Count; i++) { if (Convert.ToBoolean(dtMo.Rows[i]["chk"] == DBNull.Value ? false : dtMo.Rows[i]["chk"])) { //没id,自动保存。有id,判断是否modifyed,如果更改了,update string id = DbHelper.GetDbString(dtMo.Rows[i]["id"]); string cZt = DbHelper.GetDbString(dtMo.Rows[i]["cStatus"]); if (cZt == "审核") { //检查是否已录入工时和入库 //已录入的无法进行弃审 string sql = @" update zdy_lk_xm_gongshi set cStatus ='未审核',cverifier=null,dverifytime=null where id = @id "; DbHelper.ExecuteNonQuery(sql, new SqlParameter[] { new SqlParameter("@id", DbHelper.GetDbString(dtMo.Rows[i]["id"])) }); j++; } else { str = str + "第" + (i + 1).ToString() + "行未审核\r\n"; continue; } } } if (!string.IsNullOrEmpty(str)) { MessageBox.Show(str); } if (j > 0) { MessageBox.Show("弃审完成"); Cx(); } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }
public void ShenHe() { //校验是否有审核权限 Boolean bOn = ClsDataAuth.GetAuth(canshu.u8Login.cUserId); if (!bOn) { MessageBox.Show("没有审核权限!"); return; } try { string str = ""; gridView1.CloseEditor(); int j = 0; for (int i = 0; i < dtMo.Rows.Count; i++) { if (Convert.ToBoolean(dtMo.Rows[i]["chk"] == DBNull.Value ? false : dtMo.Rows[i]["chk"])) { //没id,自动保存。有id,判断是否modifyed,如果更改了,update string id = DbHelper.GetDbString(dtMo.Rows[i]["id"]); //没id,无法进行操作 if (string.IsNullOrEmpty(id)) { MessageBox.Show("第" + i.ToString() + "没有保存,请先保存"); return; } else { string cZt = DbHelper.GetDbString(dtMo.Rows[i]["cstatus"]); if (cZt == "未审核") { string sql = @" update zdy_lk_xm_gongshi set cStatus ='审核',cverifier=@cverifier,dverifytime=@dverifydate where id = @id "; DbHelper.ExecuteNonQuery(sql, new SqlParameter[] { new SqlParameter("@id", DbHelper.GetDbString(dtMo.Rows[i]["id"])), new SqlParameter("@cverifier", canshu.userName), new SqlParameter("@dverifydate", canshu.u8Login.CurDate) }); //处理审核事件 j++; } else { str = str + "第" + (i + 1).ToString() + "行已审核\r\n"; continue; } } } } if (!string.IsNullOrEmpty(str)) { MessageBox.Show(str); } if (j > 0) { MessageBox.Show("审核完成"); Cx(); } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }
public void Save() { comboBox1.Focus(); gridView1.PostEditor(); gridView1.UpdateCurrentRow(); string str = ""; for (int i = 0; i < dtMo.Rows.Count; i++) { string cNo = DbHelper.GetDbString(dtMo.Rows[i]["cno"]); if (string.IsNullOrEmpty(cNo)) { str = str + "第" + (i + 1) + "行项目编码未输入\r\n"; } string cName = DbHelper.GetDbString(dtMo.Rows[i]["czyxm"]); if (string.IsNullOrEmpty(cName)) { str = str + "第" + (i + 1) + "行人员姓名未输入\r\n"; } DateTime dtBegin = DbHelper.GetDbDate(dtMo.Rows[i]["dbdate"]); DateTime dtEnd = DbHelper.GetDbDate(dtMo.Rows[i]["dedate"]); if (dtEnd < dtBegin) { str = str + "第" + (i + 1) + "行截止日期小于起始日期\r\n"; } //不是同一个月份的不可保存 if (dtEnd.ToString("yyyyMM") != dtBegin.ToString("yyyyMM")) { str = str + "第" + (i + 1) + "行起始日期和截止日期不在同一个月份!\r\n"; } string cError = ""; //检查总账是否结帐,已结帐的不可更改 cError = ClsDataAuth.XZ_CheckJieZhang(dtBegin.ToString("yyyy-MM-dd")); if (cError != "") { str = str + "第" + (i + 1) + "行" + cError + "\r\n"; } } if (str != "") { CommonHelper.MsgError(str); return; } SqlTransaction tran = DbHelper.BeginTrans(); try { DataTable dt2 = dtMo.GetChanges(); if (dt2 != null) { for (int i = 0; i < dt2.Rows.Count; i++) { string cNo = DbHelper.GetDbString(dt2.Rows[i]["cno"]); string cName = DbHelper.GetDbString(dt2.Rows[i]["czyxm"]); DateTime dtBegin = DbHelper.GetDbDate(dt2.Rows[i]["dbdate"]); DateTime dtEnd = DbHelper.GetDbDate(dt2.Rows[i]["dedate"]); string cId = DbHelper.GetDbString(dt2.Rows[i]["id"]); if (string.IsNullOrEmpty(cId)) { cId = ""; } //检查日期是否冲突,和保存的数据 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@cno", cNo), new SqlParameter("@cxm", cName), new SqlParameter("@dbdate", dtBegin), new SqlParameter("@dedate", dtEnd), new SqlParameter("@id", cId), new SqlParameter("@ire", SqlDbType.Int) }; param[5].Direction = ParameterDirection.Output; DbHelper.ExecuteSqlWithTrans("zdy_lk_sp_gongshichongfu", param, CommandType.StoredProcedure, tran); //检查条码是否存在 int iRe = DbHelper.GetDbInt(param[5].Value); if (iRe == 1) { str = string.Format("项目:{0}, 人员:{1},开始日期:{2}截止日期:{3}:\r\n和之前记录冲突!", cNo, cName, dtBegin.ToShortDateString(), dtEnd.ToShortDateString()); throw new Exception(str); } else { if (cId == "") { string sql = @"insert into zdy_lk_xm_gongshi(cno ,[dbdate] ,[dedate] ,[czybm] ,[czyxm] ,[dgongshi] ,[cmemo] ,[cmaker] ,[dmaketime],cstatus) values(@cno ,@dbdate ,@dedate ,@czybm ,@czyxm ,@dgongshi ,@cmemo ,@cmaker ,getdate(),'未审核')"; DbHelper.ExecuteSqlWithTrans(sql, new SqlParameter[] { new SqlParameter("@cno", cNo), new SqlParameter("@dbdate", dtBegin), new SqlParameter("@dedate", dtEnd), new SqlParameter("@czybm", DbHelper.ToDbValue(dt2.Rows[i]["czybm"])), new SqlParameter("@czyxm", cName), new SqlParameter("@dgongshi", DbHelper.ToDbValue(dt2.Rows[i]["dgongshi"])), new SqlParameter("@cmemo", DbHelper.ToDbValue(dt2.Rows[i]["cmemo"])), new SqlParameter("@cmaker", DbHelper.ToDbValue(dt2.Rows[i]["cmaker"])) }, CommandType.Text, tran); } else { string sql = @"update zdy_lk_xm_gongshi set cno=@cno, ,dbdate=@dbdate ,dedate=@dedate ,czybm=@czybm ,czyxm=@czyxm ,dgongshi=@dgongshi ,cmemo=@cmemo where id =@id)"; DbHelper.ExecuteSqlWithTrans(sql, new SqlParameter[] { new SqlParameter("@cno", cNo), new SqlParameter("@dbdate", dtBegin), new SqlParameter("@dedate", dtEnd), new SqlParameter("@czybm", DbHelper.ToDbValue(dt2.Rows[i]["czybm"])), new SqlParameter("@czyxm", cName), new SqlParameter("@dgongshi", DbHelper.ToDbValue(dt2.Rows[i]["dgongshi"])), new SqlParameter("@cmemo", DbHelper.ToDbValue(dt2.Rows[i]["cmemo"])), new SqlParameter("@id", cId) }, CommandType.Text, tran); } } } DbHelper.CommitTransAndCloseConnection(tran); MessageBox.Show("保存成功!"); Cx(); } } catch (Exception ex) { DbHelper.RollbackAndCloseConnection(tran); MessageBox.Show(ex.Message); return; } }