private static string getdjhm()
{
DataTable FahdNumMax = SqlHelper1.ExecuteDataSetText(CommandType.StoredProcedure, "proc_get_nummax_fahd", null).Tables[0];
string djhm = FahdNumMax.Rows[0][0].ToString();
return(djhm);
}
private static string getNumber()
{
DataTable FahdNumMax = SqlHelper1.ExecuteDataSetText(CommandType.StoredProcedure, "proc_get_nummax_jggl", null).Tables[0];
string Number = FahdNumMax.Rows[0][0].ToString();
return(Number);
}
public void ProcessRequest(HttpContext context)
{
string pcontent = context.Request.Form["pcontent"];
switch (pcontent)
{
case "kehu": //客户资料
string kehuName = context.Request.Form["kehuName"];
DataTable dt = getKeHu(kehuName);
string jsonString = string.Empty;
jsonString = JsonConvert.SerializeObject(dt);
context.Response.Write(jsonString);
break;
case "djhm": //单据号码
DataTable FahdNumMax = SqlHelper1.ExecuteDataSetText(CommandType.StoredProcedure, "proc_get_nummax_fahd", null).Tables[0];
string danju_no = FahdNumMax.Rows[0][0].ToString();
context.Response.Write(danju_no);
break;
case "wuliao": //物料
break;
default:
break;
}
//string kehuName = context.Request.Form["kehuName"];
//string strSql = string.Format("SELECT top 5 fname FROM t_user");
//DataTable dt = SqlHelper1.getTable(strSql, null);
//StringBuilder sb = new StringBuilder();
//if (dt.Rows.Count > 0)
//{
// sb.Append("<table id=\"kehutable\" border=1>");
// sb.Append("<tr><th>客户ID</th><th>客户名称</th><th>客户电话</th><th>等级</th></tr>");
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// sb.Append("<tr>");
// sb.Append(string.Format("<td>{0}</td>", dt.Rows[i][0].ToString()));
// sb.Append(string.Format("<td>{0}</td>", dt.Rows[i][0].ToString()));
// sb.Append(string.Format("<td>{0}</td>", dt.Rows[i][0].ToString()));
// sb.Append(string.Format("<td>{0}</td>", dt.Rows[i][0].ToString()));
// sb.Append("</tr>");
// }
// sb.Append("</table>");
//}
//sb.Append("111");
//context.Response.Write(sb.ToString());
}
protected void danju_new_Click(object sender, EventArgs e)
{
DataTable FahdNumMax = SqlHelper1.ExecuteDataSetText(CommandType.StoredProcedure, "proc_get_nummax_fahd", null).Tables[0];
danju_no.Text = FahdNumMax.Rows[0][0].ToString();
//客户信息清空
txtkehuFNumber.Text = "";
txtkehuName.Text = "";
txtkehuPhone.Text = "";
txtkehuDengji.Text = "";
txtdjdm.Text = "";
txtywy.Text = "";
//Repeater1.DataSource = "";
//Repeater1.DataBind();
//txtkehu.Focus();
}
private static bool k3bc(string fad_ph, string kehuFNumber, string ywy, string zhidan, string bz, string kehuDengji)
{
bool djbc = false;
string DtNow = DateTime.Now.ToString("yyyy-MM-dd");
//获取表体FInterID(最大号)
DataTable FahtzdNumMax = SqlHelper1.ExecuteDataSetText(CommandType.StoredProcedure, "proc_get_nummax_fahtzd", null).Tables[0];
string FInterID = FahtzdNumMax.Rows[0][0].ToString();
//获取新增物料的表格
string sql = string.Format(@"select * from fahuodan_wl where FInterID='{0}'", fad_ph);
DataTable fahuodan = SqlHelper1.getTable(sql, null);
int fhdcount = fahuodan.Rows.Count;
if (fhdcount > 0)
{
//查询购货单位
sql = string.Format(@"select fitemid from t_Organization where fnumber='{0}'", kehuFNumber);
int FCustID = Convert.ToInt32(SqlHelper1.getTable(sql, null).Rows[0][0]);
//查询业务员ID
sql = string.Format(@"select fitemid from t_emp where fname='{0}'", ywy);
int FEmpID = Convert.ToInt32(SqlHelper1.getTable(sql, null).Rows[0][0]);
//查询制单人ID
sql = string.Format(@"select FUserID from t_User where fname='{0}'", zhidan);
int FbUserID = Convert.ToInt32(SqlHelper1.getTable(sql, null).Rows[0][0]);
//发货通知单表体生成
for (int i = 0; i < fhdcount; i++)
{
//获取FItemID和FUnitID
string FNumber = fahuodan.Rows[i]["FNumber"].ToString();
sql = string.Format(@"select FItemID,FUnitID from t_icitem where FNumber='{0}'", FNumber);
DataTable dt = SqlHelper1.getTable(sql, null);
int FItemID = Convert.ToInt32(dt.Rows[0][0]);
int FUnitID = Convert.ToInt32(dt.Rows[0][1]);
decimal FQty = Convert.ToDecimal(fahuodan.Rows[i]["Amount"]);
decimal FPrice = Convert.ToDecimal(fahuodan.Rows[i]["Price"]);
decimal Famount = Convert.ToDecimal(fahuodan.Rows[i]["Total"]);
//SQL插入语句
sql = string.Format(@"INSERT INTO SEOutStockEntry (FInterID,FEntryID,
FBrNo,FMapNumber,FMapName,FItemID,Fauxqty,Fauxprice,Famount,FUnitID,FBatchNo,
FAuxPropID,FQty,FSecCoefficient,FSecQty,Fnote,FSourceBillNo,FSourceTranType,
FSourceInterId,FSourceEntryID,FContractBillNo,FContractInterID,
FContractEntryID,FOrderBillNo,FOrderInterID,FOrderEntryID,FAuxInvoiceQty,
FInvoiceQty,FFetchDate,FStockID,FStdAmount,FPlanMode,FMTONo,FClientEntryID,
FClientOrderNo) values({0},{1},'0','','',{2},{3},{4},{5},{6},'',0,{3},0,0,'','',0,0,0,'',0,0,'',0,0,{3},{3},
'{7}',0,{5},14036,'','','')", FInterID, i + 1, FItemID, FQty, FPrice, Famount, FUnitID, DtNow);
SqlHelper1.ExecteNonQueryText(sql, null);
}
//发货通知单表头生成
//获取单据号码(流水号)
DataTable FdjNO = SqlHelper1.ExecuteDataSetText(CommandType.StoredProcedure, "proc_get_nummax_fhdjhm", null).Tables[0];
int FBlsh = Convert.ToInt32(FdjNO.Rows[0][0]);
string djt = "SEOUT";
string rjyear = DtNow.Substring(2, 2);
string rjmonth = DtNow.Substring(5, 2);
string lsh;
if (FBlsh >= 10000000)
{
lsh = FBlsh.ToString();
}
else if (FBlsh >= 1000000)
{
lsh = "0";
}
else if (FBlsh >= 100000)
{
lsh = "00";
}
else
{
lsh = "000";
}
string FBillNo = djt + rjyear + rjmonth + lsh + FBlsh;
/*(FInterID,FBillNo,FStatus,Fdate,FCustID,FCheckDate,FManagerID,FEmpID,
* FBillerID,FExplanation,FHeadSelfS0238,FHeadSelfS0239,FHeadSelfS0240)*/
sql = string.Format(@"INSERT INTO SEOutStock(FInterID,FBillNo,FBrNo,
FTranType,FCancellation,FStatus,Fdate,FCurrencyID,
FCustID,FSalType,FCheckDate,FManagerID,FDeptID,FEmpID,FBillerID,
FSettleID,FExchangeRateType,FExchangeRate,FMultiCheckDate1,
FMultiCheckDate2,FMultiCheckDate3,FMultiCheckDate4,
FMultiCheckDate5,FMultiCheckDate6,FRelateBrID,FSelTranType,
FFetchAdd,FExplanation,FAreaPS,FManageType,FPrintCount,
FHeadSelfS0238,FHeadSelfS0239,FHeadSelfS0240) values({0},'{1}',
'0',83,0,{2},'{3}',1,{4},101,'{3}',15495,14053,{5},{6},
0,1,1,Null,Null,Null,Null,Null,Null,0,81,'','{7}',20302,0,0,{5},{5},'{8}')",
FInterID, FBillNo, 0, DtNow, FCustID, FEmpID, FbUserID, bz, kehuDengji);
SqlHelper1.ExecteNonQueryText(sql, null);
djbc = true;
}
return(djbc);
}