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;
}
}
