public bool Insert(string a, string b, string c)
{
string s = "insert into Nprocessing(pId,LID,Lname) values('" + a + "','" + b + "','" + c + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//设置罚款进行罚款处理
public bool insert6(int a, int b, int c, int d)
{
string s = "insert into apmoney(p1,p2,p3,cb)values('" + a + "','" + b + "','" + c + "','" + d + "')";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool insert4(int a, string b, DateTime c, DateTime d)
{
string s = "insert into attendance(useId,username,date,afternoonend)values('" + a + "','" + b + "','" + c + "','" + d + "')";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool update1028(string a, string b, string c)
{
string s = "UPDATE nprocessing2 set page = '" + c + "' WHERE getId = '" + a + "' and bh = '" + b + "' ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool insert5(DateTime b, DateTime c, DateTime d, DateTime e)
{
string s = "insert into aspunch(smw, sme,saw,sae) values('" + b + "','" + c + "','" + d + "','" + e + "')";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert222(processfile w)
{
string s = "INSERT INTO projecterror (getId,backtime) VALUE ('" + w.getId + "','" + w.processdate + "')";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert456(workstatus w)
{
string s = "insert into processing(lq,cf,zl,dm,sm,bm,tc,zj,gj,hy,gh,pId,status1,flag,projectunit) values('" + w.lq + "','" + w.cf + "','" + w.zl + "','" + w.dm + "','" + w.sm + "','" + w.bm + "','" + w.tc + "','" + w.zj + "','" + w.gj + "','" + w.hy + "','" + w.gh + "','" + w.dangId + "','" + w.status + "','" + w.flag + "','" + w.projectUnit + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool update101508(string a, string b, string c)
{
string s = "update nprocessing2 set zrr ='" + c + "' where getId = '" + a + "' and bh ='" + b + "' and LID = '11' ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool insert(int a, int b)
{
string s = "insert into role_res values('" + a + "','" + b + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool update(string a, string b, string c)
{
string s = "update test set " + a + " ='" + b + "' where 项目号 = '" + c + "' ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool insert444(string a, string b, string c, string d, string e)
{
string s = "insert into test(pId,zId,sx,parentId,parentId2) values('" + a + "','" + b + "','" + c + "','" + d + "','" + e + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool insert3(string a, string b, string c, string d, string e)
{
string s = "insert into project3(dangId,filename,filetype,gdmethod,year) values('" + a + "','" + b + "','" + c + "','" + d + "','" + e + "')";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert1128(string a, string b)
{
string s = "insert into project1(url,hz) values('" + a + "','" + b + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert101(string a, string b, string c, string d, string e)
{
string s = "insert into jd(pId,LID,Lname,up,down) values('" + a + "','" + b + "','" + c + "','" + d + "','" + e + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//修改加工流转单状态
public bool update4(processfile p)
{
string s = "UPDATE fileprocess set year = '" + p.year + "',page ='" + p.page + "',responesible='" + p.responseible + "',process = '" + p.process + "',processdate = '" + p.processdate + "' WHERE bh = '" + p.bh + "'";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool update112703(string a)
{
string s = "delete from nprocessing2 where getId = '" + a + "'";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert111(getfile w, int p)
{
string s = "INSERT INTO projecterror (projectunit,getId,page) VALUE ('" + w.processunit + "','" + w.getId + "','" + p + "')";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool insert1(string str)
{
string s = "insert into users(uname) values('" + str + "')";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert123(getfile w)
{
string s = "insert into fileback(projectunit,getId,gettime,dangId,filetype,gdmethod,year,question,projectunit2,processunit,swapdate,swapdate2) values('" + w.projectunit + "','" + w.getId + "','" + w.gettime + "','" + w.dangId + "','" + w.filetype + "','" + w.gdmethod + "','" + w.year + "','" + w.question + "','" + w.projetunit2 + "','" + w.processunit + "','" + w.swapdate + "','" + w.swapdate2 + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool update19(string a, string b)
{
string s = "UPDATE nprocessing2 set status = 1 WHERE getId = '" + a + "' and bh = '" + b + "' and LID = 10";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//修改工作状态
public bool update(string a)
{
string s = "UPDATE processing set status1 = status1 + 1 WHERE dangId = '" + a + "'";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//自定义工作流
public bool Insert(workstatus w)
{
string s = "update processing set lq = '" + w.lq + "', cf = '" + w.cf + "', zl = '" + w.zl + "',dm = '" + w.dm + "', sm = '" + w.sm + "', bm = '" + w.bm + "', tc = '" + w.tc + "',zj = '" + w.zj + "',gj = '" + w.gj + "',hy = '" + w.hy + "', gh = '" + w.gh + "' ,flag = '" + w.flag + "' ,projectunit = '" + w.projectUnit + "' where pId = '" + w.dangId + "'";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert1107(string a, int b, string c)
{
string s = " insert into photourl(dangId,flag,url) values('" + a + "','" + b + "','" + c + "')";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool update30(string a, string b)
{
string s = "UPDATE nprocessing2 set status = 0 , zrr = null WHERE bh = '" + a + "' and getId = '" + b + "' and (LID = 10 OR LID = 11)";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//更新档次
public bool update3(string a, int b, int c)
{
string s = "UPDATE attendance set dc ='" + a + "' where id ='" + b + "' and useId = '" + c + "'";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert20(processfile w)
{
string s = "insert into fileprocess10(projectunit,getId,lzId,filetype,gdmethod,year,dangId,process,processdate,responesible,page) values('" + w.projectunit + "','" + w.getId + "','" + w.lzId + "','" + w.filetype + "','" + w.gdmethod + "','" + w.year + "','" + w.bh + "','" + w.process + "','" + w.processdate + "','" + w.responseible + "','" + w.page + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool update4(int a, int b, string c, int d, DateTime e)
{
string s = "UPDATE attendance set mealsupport = '" + a + "',punish='" + b + "',allwork='" + c + "'WHERE useId='" + d + "' and date='" + e + "'";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//添加挂接档案问题单
public bool Insert22(getfile w)
{
string s = "insert into fileproblem10(bh,projectunit,getId,gettime,dangtype,gdmethod,year,problem,projectunit2,processunit,swapdate,swapdate2,solve) values('" + w.bh + "','" + w.projectunit + "','" + w.getId + "','" + w.gettime + "','" + w.filetype + "','" + w.gdmethod + "','" + w.year + "','" + w.question + "','" + w.projetunit2 + "','" + w.processunit + "','" + w.swapdate + "','" + w.swapdate2 + "','" + w.solve + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//若已经存在一次打卡，其余的打卡就直接更新进去
public bool update(string a, DateTime b, int c, DateTime d)
{
string s = "update attendance set " + a + " ='" + b + "' where useId = '" + c + "' and date='" + d + "'";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert4444(string a, string b)
{
string s = "insert into zd(pId,zd) values('" + a + "','" + b + "') ";
int rows = DBhelper.ExecuteNonQuery(s);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}