public static string GetNewPid() { string strCID = ""; string strYMD = DateTime.Now.ToString("yyyyMMdd"); string strSelPID = "select * from PurchaseApplication where DateRecord='" + strYMD + "'"; DataTable dtPMaxID = SQLBase.FillTable(strSelPID, "MainPP"); int intNewID = 0; if (dtPMaxID == null) { return(strCID); } if (dtPMaxID.Rows.Count == 0) { string strInsertID = "insert into PIDNo (PID,PidNo,DateRecord) values('S',0,'" + strYMD + "')"; SQLBase.ExecuteNonQuery(strInsertID, "SalesDBCnn"); intNewID = 0; } else { intNewID = Convert.ToInt32(dtPMaxID.Rows[0]["PidNo"]); } intNewID++; string str = "select PID, PidNo,DateRecord from PIDNo where DateRecord='" + strYMD + "'"; dtPMaxID = SQLBase.FillTable(strSelPID, "SalesDBCnn"); strCID = dtPMaxID.Rows[0]["CID"].ToString() + DateTime.Now.ToString("yyyyMMdd") + GFun.GetNum(intNewID, 3); return(strCID); }
public static string GetSPid(string folderBack) { string[] arr = folderBack.Split('/'); Acc_Account account = GAccount.GetAccountInfo(); int unitId = Convert.ToInt16(account.UnitID); string strPID = ""; string strYMD = DateTime.Now.ToString("yyMMdd"); string strSelPID = "select SPID, SPidNo from [" + arr[0] + "].." + arr[6] + " where DateRecord='" + strYMD + "'"; DataTable dtPMaxID = SQLBase.FillTable(strSelPID); int intNewID = 0; if (dtPMaxID == null) { return(strPID); } if (dtPMaxID.Rows.Count == 0) { string strInsertID = "insert into [" + arr[0] + "].." + arr[6] + " (SPID,SPidNo,DateRecord) values('P',0,'" + strYMD + "')"; SQLBase.ExecuteNonQuery(strInsertID); intNewID = 0; } else { intNewID = Convert.ToInt32(dtPMaxID.Rows[0]["SPidNo"]); } intNewID++; string strUpdateID = "update [" + arr[0] + "].." + arr[6] + " set SPidNo='" + intNewID + "' where DateRecord ='" + strYMD + "'"; SQLBase.ExecuteNonQuery(strUpdateID); strPID = dtPMaxID.Rows[0]["SPID"].ToString() + DateTime.Now.ToString("yyMMdd") + GFun.GetNum(unitId, 4) + GFun.GetNum(intNewID, 4); return(strPID); }