public string BjFormChgStatus() { string responsetxt = string.Empty; HttpContextBase context = this.HttpContext; string CodeStr = context.Request.Params["code"]; string StatusStr = context.Request.Params["chgstatus"]; SqlParameter[] spara = new SqlParameter[] { new SqlParameter("@code", CodeStr), new SqlParameter("@chgstatus", StatusStr) }; try { int resultcode = KDATA.ExecuteNonQuery("update bjform_m set status=@chgstatus where code=@code", spara); if (resultcode > 0) { responsetxt = "success"; } else { responsetxt = "error"; } }catch (Exception ex) { throw ex; } return(responsetxt); }
public string DelBjForm() { string responsetxt = string.Empty; HttpContextBase context = this.HttpContext; string codeStr = context.Request.Params["code"]; SqlParameter[] spara = new SqlParameter[] { new SqlParameter("@code", codeStr) }; try { int resultcode = KDATA.ExecuteNonQuery("delete bjform_m where status=0 and code=@code", spara); if (resultcode > 0) { responsetxt = "已删除报检单"; } else { responsetxt = "删除有误"; } }catch (Exception ex) { throw ex; } return(responsetxt); }
public void UpdateBjfrom(NameValueCollection forms, out string responsetxt) { string code = forms.Get("code").ToString().Trim(); string buyer = forms.Get("buyer").ToString(); string supplier = forms.Get("supplier").ToString(); SqlParameter[] spara = new SqlParameter[] { new SqlParameter("@code", code), new SqlParameter("@buyer", buyer), new SqlParameter("@supplier", supplier) }; try { int resultcode = KDATA.ExecuteNonQuery("update bjform_m set buyer=@buyer,supplier=@supplier where code=@code", spara); if (resultcode > 0) { responsetxt = "已保存"; } else { responsetxt = "保存有误,联系管理员"; } } catch (Exception ex) { throw ex; } }
public string AddBjFormDetail() { string responsetxt = string.Empty; HttpContextBase context = this.HttpContext; string CodeStr = context.Request.Params["code"]; string TypeStr = context.Request.Params["ptype"]; string PcodeStr = context.Request.Params["pcode"]; string PdescStr = context.Request.Params["pdesc"]; string PsizeStr = context.Request.Params["psize"]; string PunitStr = context.Request.Params["punit"]; float Checkamount = Convert.ToSingle(context.Request.Params["puramount"]); string sqlStr = string.Empty; SqlParameter[] spara = new SqlParameter[] { new SqlParameter("@code", CodeStr), new SqlParameter("@pcode", PcodeStr), new SqlParameter("@desc", PdescStr), new SqlParameter("@size", PsizeStr), new SqlParameter("@unit", PunitStr), new SqlParameter("@purchaseamount", Checkamount) }; if (TypeStr == "80") { sqlStr = "insert into bjform_d (code, pcode, purchaseamount) values(@code, @pcode, @purchaseamount)"; } else { sqlStr = "insert into bjform_d_others (code,description,size,unit,purchaseamount) values (@code,@desc,@size,@unit,@purchaseamount)"; } try { int resultcode = KDATA.ExecuteNonQuery(sqlStr, spara); if (resultcode > 0) { responsetxt = "已保存"; } else { responsetxt = "保存有误,联系管理员"; } } catch (Exception ex) { throw ex; } return(responsetxt); }
public string DelBjFormDetail() { string responsetxt = string.Empty; HttpContextBase context = this.HttpContext; string codestr = context.Request.Params["code"]; string typestr = context.Request.Params["type"]; string pcodestr = context.Request.Params["pcode"]; string[] pcodearray = pcodestr.Split('|'); string pcodesql = string.Empty; string tablesql = string.Empty; foreach (string pcode in pcodearray) { pcodesql = pcodesql + ",'" + pcode + "'"; } pcodesql = pcodesql.Substring(1); if (typestr == "材料") { tablesql = "delete bjform_d where code='" + codestr.Trim() + "' and pcode in (" + pcodesql + ")"; } else { tablesql = "delete bjform_d_others where code='" + codestr.Trim() + "' and description in (" + pcodesql + ")"; } try { int resultcode = KDATA.ExecuteNonQuery(tablesql); if (resultcode > 0) { responsetxt = "已保存"; } else { responsetxt = "保存有误,联系管理员"; } } catch (Exception ex) { throw ex; } return(responsetxt); }
public void AddBjForm(NameValueCollection forms, out string responsetxt) { string bjformcode = forms.Get("code").ToString(); string urgent = forms.Get("urgent").ToString(); string type = forms.Get("type").ToString(); string maker = forms.Get("maker").ToString(); string buyer = forms.Get("buyer").ToString(); string supplier = forms.Get("supplier").ToString(); string status = "0"; string makedate = forms.Get("makedate").ToString(); SqlParameter[] spara = new SqlParameter[] { new SqlParameter("@code", bjformcode), new SqlParameter("@urgent", urgent), new SqlParameter("@type", type), new SqlParameter("@maker", maker), new SqlParameter("@buyer", buyer), new SqlParameter("@supplier", supplier), new SqlParameter("@status", status), new SqlParameter("@makedate", makedate) }; try { int resultcode = KDATA.ExecuteNonQuery(@"insert into bjform_m (urgent,type,code,maker,buyer,supplier,status,makedate) values (@urgent,@type,@code, (select top 1 username from qc_staff where profile.value('(/root/Chinesename)[1]','nvarchar(max)')=@maker) , @buyer,@supplier,@status,@makedate)", spara); if (resultcode > 0) { responsetxt = "已保存"; } else { responsetxt = "保存有误,联系管理员"; } } catch (Exception ex) { throw ex; } }
public void UpdateBjfromByQc(NameValueCollection forms, out string responsetxt) { string codeStr = forms.Get("code").Trim(); string qcmanagerStr = forms.Get("qcmanager"); string qcstaffStr = forms.Get("qcstaff"); string statusStr = forms.Get("status"); SqlParameter[] spara = new SqlParameter[] { new SqlParameter("@code", codeStr), new SqlParameter("@manager", qcmanagerStr), new SqlParameter("@staff", qcstaffStr), new SqlParameter("@status", statusStr) }; try { string sqlstr = "update bjform_m "; sqlstr += "set qcstaff=(select top 1 username from qc_staff where profile.value('(/root/Chinesename)[1]','nvarchar(max)')='" + qcstaffStr + "'),"; sqlstr += "qcmanager=(select top 1 username from qc_staff where profile.value('(/root/Chinesename)[1]','nvarchar(max)')='" + qcmanagerStr + "'),"; sqlstr += "status=(select top 1 bjstatus from bjformstcode where bjtext='" + statusStr + "') "; sqlstr += "where code='" + codeStr + "'"; int resultcode = KDATA.ExecuteNonQuery(sqlstr); if (resultcode > 0) { responsetxt = "success"; } else { responsetxt = "error"; } }catch (Exception ex) { throw ex; } }
public string Updateqcitem() { string responsetxt = string.Empty; HttpContextBase context = this.HttpContext; string SubmitStr = context.Request.Params["submit"]; JObject jo = (JObject)JsonConvert.DeserializeObject(SubmitStr); string codestr = jo["code"].ToString(); string pcodestr = string.Empty; if (jo["pcode"] != null) { pcodestr = jo["pcode"].ToString(); } else { pcodestr = jo["desc"].ToString(); } decimal checkamount = Convert.ToDecimal(jo["checkamount"]); decimal passamount = Convert.ToDecimal(jo["passamount"]); decimal finalpassamount = Convert.ToDecimal(jo["finalpassamount"]); decimal checkrate = Convert.ToDecimal(jo["checkrate"].ToString().TrimEnd('%')) / 100; decimal passrate = Convert.ToDecimal(jo["passrate"].ToString().TrimEnd('%')) / 100; string qcnotestr = jo["qcnote"].ToString(); string directornotestr = jo["directornote"].ToString(); string checkdatestr = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); XmlDocument xdoc; XmlElement xelement; xdoc = new XmlDocument(); xelement = xdoc.CreateElement("", "root", ""); xdoc.AppendChild(xelement); XmlElement staffnote = xdoc.CreateElement("staffnote"); staffnote.InnerText = qcnotestr; XmlElement directornote = xdoc.CreateElement("directornote"); directornote.InnerText = directornotestr; xelement.AppendChild(staffnote); xelement.AppendChild(directornote); string notestr = xdoc.OuterXml; SqlParameter[] spara = new SqlParameter[] { new SqlParameter("@code", codestr), new SqlParameter("@pcode", pcodestr), new SqlParameter("@checkamount", checkamount), new SqlParameter("@passamount", passamount), new SqlParameter("@finalpassamount", finalpassamount), new SqlParameter("@checkrate", checkrate), new SqlParameter("@passrate", passrate), new SqlParameter("@note", notestr), new SqlParameter("@checkdate", checkdatestr) }; string sqlStr = string.Empty; if (jo["pcode"] == null) { sqlStr = @"update bjform_d_others set checkamount=@checkamount,passamount=@passamount,finalpassamount=@finalpassamount,checkrate=@checkrate,passrate=@passrate,note=@note,checkdate=@checkdate where code=@code and description=@pcode"; } else { sqlStr = @"update bjform_d set checkamount=@checkamount,passamount=@passamount,finalpassamount=@finalpassamount,checkrate=@checkrate,passrate=@passrate,note=@note,checkdate=@checkdate where code=@code and pcode=@pcode"; } try { int resultcode = KDATA.ExecuteNonQuery(sqlStr, spara); if (resultcode > 0) { responsetxt = "updateqcitemsuccess"; } else { responsetxt = "error"; } } catch (Exception ex) { throw ex; } return(responsetxt); }