private void loadData()
{
DataSet ds = new DataSet();
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
string sql = "sp_gam_cem_forecast_view";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
ds = sqldb.getDataSetCmd(ref cmd);
cmd.Connection.Dispose();
cmd.Dispose();
}
DataColumn[] OEM;
DataColumn[] DATA;
OEM = new DataColumn[] { ds.Tables[1].Columns["oem"], ds.Tables[1].Columns["plant"]};
DATA = new DataColumn[] { ds.Tables[0].Columns["oem"], ds.Tables[0].Columns["plant"]};
DataRelation drl = new DataRelation("myDataRelation", OEM, DATA,true);
drl.Nested = true;
ds.Relations.Add(drl);
main.DataSource = ds.Tables[1];
main.DataBind();
}
public static string getPartNoHistory(string iPN,string code)
{
//string result = "<span>No user found!</span>";
DataTable dt = new DataTable();
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
string sql = "select top 10 OEM,plant,cus_part_no,qty,price,amount,sqft,asp = case when amount=0 or sqft=0 then 0 else amount/sqft end,"+
"Convert(datetime, gamDate, 112) as lastDate from dbo.cemFC_ship_and_mss where int_part_no=@ipn and customer_code=@code order by gamDate desc";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ipn", iPN);
cmd.Parameters.AddWithValue("@code", code);
dt = sqldb.getDataTableWithCmd(ref cmd);
cmd.Connection.Dispose();
cmd.Dispose();
}
StringBuilder sb = new StringBuilder();
sb.Append("<table class='standardTable' border='1' cellpadding='1' cellspacing='0' borderColor='#cccccc' width='250' bgcolor='#FFFBBC'>"+
"<tr bgcolor='#C6976B'><th>Part#</th><th>Qty</th><th>Price</th><th>Amount</th><th>Sqft</th><th>ASP</th><th>Date</th></tr>");
foreach (DataRow row in dt.Rows)
{
//sb.Append(String.Format("<tr><td nowrap=true>{0}</td><td align='right'>{1:N0}</td><td>{2:N3}</td><td>{3:d}</tr>", row[2], row[3],row[4],row[8]));
sb.Append(String.Format("<tr bgcolor='#C5EACB'><td>{0}</td><td align='right'>{1:N0}</td><td align='right'>{2:N2}</td><td align='right'>{3:N2}</td><td align='right'>{4:N4}</td><td align='right'>{5:N2}</td><td>{6:dd MMM yyyy}</tr>",
row[2], row[3], row[4],row[5],row[6],row[7], row[8]));
}
sb.Append("</table>");
dt.Dispose();
return sb.ToString();
}
protected void confirmUpload_Click(object sender, EventArgs e)
{
tmp.Text = "";
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
string sql = "sp_gam_b2f_overwrite";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.StoredProcedure;
sqldb.execSqlWithCmd(ref cmd);
//cmd.Dispose();
cmd = new SqlCommand("sp_gam_b2f_add");
cmd.CommandType = CommandType.StoredProcedure;
foreach (ListViewDataItem item in listMain.Items)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@fcPeriod", ((Label)item.FindControl("period")).Text);
cmd.Parameters.AddWithValue("@sales", ((Label)item.FindControl("sales")).Text);
cmd.Parameters.AddWithValue("@oem", ((Label)item.FindControl("oem")).Text);
cmd.Parameters.AddWithValue("@cpn", ((Label)item.FindControl("cpn")).Text);
cmd.Parameters.AddWithValue("@pn", ((Label)item.FindControl("ipn")).Text);
cmd.Parameters.AddWithValue("@sqft", Convert.ToSingle(((Label)item.FindControl("sqft")).Text));
cmd.Parameters.AddWithValue("@qty", ((Label)item.FindControl("qty")).Text);
cmd.Parameters.AddWithValue("@array", ((Label)item.FindControl("array")).Text);
cmd.Parameters.AddWithValue("@smt", ((Label)item.FindControl("smt")).Text);
cmd.Parameters.AddWithValue("@fpc", ((Label)item.FindControl("fpc")).Text);
cmd.Parameters.AddWithValue("@bom", ((Label)item.FindControl("bom")).Text);
sqldb.execSqlWithCmd(ref cmd);
}
cmd.Connection.Dispose();
cmd.Dispose();
}
loadExistsData();
}
public nUser(string user_id, string domainName)
{
_isLdapUser = _isDbUser = false;
domain = "asia";
if (domainName != "")
domain = domainName;
Multek.LDAP ldap = new Multek.LDAP(@"LDAP://DC=" + domain + ",DC=ad,DC=flextronics,DC=com");
if (ldap.findUser(user_id,domain))
{
_isLdapUser = true;
_UID = ldap.uid;
userName = ldap.name;
emailAddress = ldap.email;
jobTitle = ldap.title;
fax = ldap.fax;
tel = ldap.tel;
mobile = ldap.mobile;
ipphone = ldap.ipPhone;
department = ldap.department;
DataTable dt = getDbUser(_UID, domain);
if (dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
_isDbUser = true;
_sysUserId = (int)row["sysUserId"];
managerId = (int)row["managerId"];
isReportViewer = (bool)row["isReportViewer"];
isSales = (bool)row["isSales"];
isActive = (bool)row["isActive"];
isAdmin = (bool)row["isAdmin"];
isPriceView = (bool)row["isPriceView"];
uGroup = row["uGroup"].ToString();
}
}
else
{
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_GAM_UserUpdate");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@uid", user_id);
cmd.Parameters.AddWithValue("@domain", domain);
cmd.Parameters.AddWithValue("@username", "unknow");
cmd.Parameters.AddWithValue("@isReportViewer", false);
cmd.Parameters.AddWithValue("@isSales", false);
cmd.Parameters.AddWithValue("@isActive", false);
cmd.Parameters.AddWithValue("@isAdmin", false);
cmd.Parameters.AddWithValue("@isPriceView", false);
cmd.Parameters.AddWithValue("@group", "Disabled");
sqldb.execSqlWithCmd(ref cmd);
cmd.Dispose();
}
_UID = domain = "";
msg = "User not found.";
}
ldap.Dispose();
}
public DataTable GETFS(int period, int oemid)
{
DataTable dt = new DataTable();
string oem, baan, plant;
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "[sp_gam_ForecastCustomerPart_Get]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@period", period);
cmd.Parameters.AddWithValue("@oemid", oemid);
cmd.Parameters.AddWithValue("@periodLong", 3);
cmd.Parameters.AddWithValue("@totalPeriod", 11);
SqlParameter _oem = cmd.Parameters.AddWithValue("@oem", "");
_oem.Size = 100;
SqlParameter _baan = cmd.Parameters.AddWithValue("@baanName", "");
_baan.Size = 100;
SqlParameter _plant = cmd.Parameters.AddWithValue("@plant", "");
_plant.Size = 3;
_plant.SqlDbType = SqlDbType.NVarChar;
_oem.Direction = ParameterDirection.Output;
_baan.Direction = ParameterDirection.Output;
_plant.Direction = ParameterDirection.Output;
DataSet ds = db.getDataSetCmd(ref cmd);
oem = _oem.Value.ToString();
baan = _baan.Value.ToString();
plant = _plant.Value.ToString();
bool isCEM = false;
DataTable cems = Forecast.getCEM_OEMS();
//temp.Text = cems.Rows[0][0].ToString();
foreach(DataRow row in cems.Rows)
{
if (row[0].ToString().Trim().ToUpper() == baan.Trim().ToUpper())
{
isCEM = true;
break;
}
}
dt = modDS(ds);
if (isCEM)
{
for(int i = dt.Rows.Count-1; i >=0; i--)
{
DataRow row = dt.Rows[i];
if (row["cus_part_no"].ToString().IndexOf("[") < 0)
dt.Rows.Remove(row);
}
}
cmd.Dispose();
}
return dt;
}
public static DataTable gets()
{
DataTable dt = new DataTable();
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_salesmanGet");
cmd.CommandType = CommandType.StoredProcedure;
dt = sqldb.getDataTableWithCmd(ref cmd);
cmd.Dispose();
}
return dt;
}
public static DataTable getGroup()
{
DataTable dt = new DataTable();
using (Multek.SqlDB sqldb = new Multek.SqlDB(ConfigurationManager.ConnectionStrings["GAMconn"].ToString()))
{
SqlCommand cmd = new SqlCommand("sp_gam_BaanOEMGroupList");
cmd.CommandType = CommandType.StoredProcedure;
dt = sqldb.getDataTableWithCmd(ref cmd);
cmd.Dispose();
}
return dt;
}
public static void copyPreviousPreiodForecastData(int period, int salesman)
{
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_SalesFCST_copy_previous_preiod");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@sid", salesman);
cmd.Parameters.AddWithValue("@period", period);
sqldb.execSqlWithCmd(ref cmd);
cmd.Dispose();
}
}
public static DataTable getOEMByGroup(string group)
{
DataTable dt = new DataTable();
using (Multek.SqlDB sqldb = new Multek.SqlDB(ConfigurationManager.ConnectionStrings["GAMconn"].ToString()))
{
SqlCommand cmd = new SqlCommand("sp_gam_BaanOEMsSearching");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@group", group);
dt = sqldb.getDataTableWithCmd(ref cmd);
cmd.Dispose();
}
return dt;
}
public static int currentPeriodAdd(int num)
{
int cd = 0;
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_currentPeriodAdd");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@addNumber", num);
cd = Convert.ToInt32(sqldb.getSignalValueCmd(ref cmd));
cmd.Dispose();
}
return cd;
}
public static int currentPeriod()
{
int cd = 0;
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
string sql;// = "sp_currentPeriodAdd";
sql = "sp_currentPeriod";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@addNumber", -1);
cd = Convert.ToInt32(sqldb.getSignalValueCmd(ref cmd));
cmd.Dispose();
}
return cd;
}
public string getCusPartActualHistory(int oemid, string customerPart)
{
string rq = "";
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_gam_actualItemHistory_get";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@oemid", oemid);
cmd.Parameters.AddWithValue("@cspart", customerPart);
DataTable dt = db.getDataTableWithCmd(ref cmd);
cmd.Dispose();
rq = Multek.Util.DT2JSON(dt);
}
return rq;
}
public OEMBaan(int oemId)
{
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_BaanOEMsSearching");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", oemId);
DataTable dt = sqldb.getDataTableWithCmd(ref cmd);
cmd.Dispose();
if (dt.Rows.Count == 1)
{
_BaanOEMID = (int)dt.Rows[0]["BaanOEMId"];
OEMName = dt.Rows[0]["oemname"].ToString();
Plant = dt.Rows[0]["plant"].ToString();
GroupName = dt.Rows[0]["groupname"].ToString();
}
}
}
public static DataSet getRportCompareP2P(int p1, int p2, out string message)
{
message = "";
DataSet ds = new DataSet();
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_CompareForecastOEM");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@basePeriod", p1);
cmd.Parameters.AddWithValue("@comparePeriod", p2);
SqlParameter _msg = cmd.Parameters.AddWithValue("@message", "");
_msg.Size = 1000;
_msg.Direction = ParameterDirection.Output;
ds = db.getDataSetCmd(ref cmd);
message = _msg.Value.ToString();
cmd.Dispose();
}
return ds;
}
public static DataTable getB2FResult(int period)
{
string msg = "";
DataTable dt = new DataTable();
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
string sql = "sp_gam_b2f_report";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@up", period);
SqlParameter _msg = cmd.Parameters.AddWithValue("@msg", "");
_msg.Size = 200;
_msg.Direction = ParameterDirection.Output;
db.execSqlWithCmd(ref cmd);
msg = _msg.Value.ToString();
dt = db.getDataTableWithCmd(ref cmd);
cmd.Dispose();
}
return dt;
}
public string delOEMComments(int comment_id, int oemid)
{
string author = "";
if (HttpContext.Current.Session["usr"] != null)
{
nUser usr = (nUser)Session["usr"];
author = usr.userName;
usr.Dispose();
}
if (author != "")
{
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_oem_comments_del");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@comment_id", comment_id);
cmd.Parameters.AddWithValue("@author", author);
db.execSqlWithCmd(ref cmd);
cmd.Dispose();
}
}
return getOEMComments(oemid);
}
private string GETFS(int period, int oemid)
{
string rq = "";
string oem, baan, plant;
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "[sp_gam_ForecastCustomerPart_Get]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@period", period);
cmd.Parameters.AddWithValue("@oemid", oemid);
cmd.Parameters.AddWithValue("@periodLong", 3);
SqlParameter _oem = cmd.Parameters.AddWithValue("@oem", "");
_oem.Size = 100;
SqlParameter _baan = cmd.Parameters.AddWithValue("@baanName", "");
_baan.Size = 100;
SqlParameter _plant = cmd.Parameters.AddWithValue("@plant", "");
_plant.Size = 3;
_plant.SqlDbType = SqlDbType.NVarChar;
_oem.Direction = ParameterDirection.Output;
_baan.Direction = ParameterDirection.Output;
_plant.Direction = ParameterDirection.Output;
DataSet ds = db.getDataSetCmd(ref cmd);
DataTable dt = modDS(ds);// ds.Tables[0];
oem = _oem.Value.ToString();
baan = _baan.Value.ToString();
plant = _plant.Value.ToString();
cmd.Dispose();
rq = Multek.Util.DT2JSON(dt);
dt.Dispose();
}
return "ob = {oem:{id:\"" + oemid + "\",oem:\"" + oem + "\",baan:\"" + baan + "\",plant:\"" + plant + "\"},result:" + rq + "}";
}
public string updateOLS_TopSide_adjust(int period, int oemid, int amt, string adjustType, int x, int y)
{
int gtt = 0;
int stt = 0;
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_forecast_TopSide_adjustment");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@oemid", oemid);
cmd.Parameters.AddWithValue("@period", period);
cmd.Parameters.AddWithValue("@adjust", amt);
cmd.Parameters.AddWithValue("@isOLS", (adjustType == "ols") ? true : false);
SqlParameter _gtt = cmd.Parameters.AddWithValue("@grandTtl", 0);
_gtt.Direction = ParameterDirection.Output;
SqlParameter _stt = cmd.Parameters.AddWithValue("@salesTtl", 0);
_stt.Direction = ParameterDirection.Output;
db.execSqlWithCmd(ref cmd);
gtt = Convert.ToInt32(_gtt.Value);
stt = Convert.ToInt32(_stt.Value);
cmd.Dispose();
}
return "{x:" + x.ToString() + ",y:" + y.ToString() + ",amt:" + amt.ToString() + ",gtt:" + gtt.ToString()
+ ",stt:" + stt.ToString() + "}";
}
public string setCusPartRemark(int oemid, string customerPart, string new_remark, float new_asp)
{
string remark = "{}";
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_gam_actualItemRemark_set";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@oemid", oemid);
cmd.Parameters.AddWithValue("@part_no", customerPart.Trim());
cmd.Parameters.AddWithValue("@remark", new_remark.Trim());
cmd.Parameters.AddWithValue("@asp",new_asp);
db.execSqlWithCmd(ref cmd);
cmd.Dispose();
remark = getCusPartRemark(oemid, customerPart);
}
return remark;
}
public string getPartForecastHistory(int period, int oemid,string project)
{
string sql = "select top 6 * from dbo.gam_part_forecast_log where oem_id=@oemid and project=@project and period = @period order by log_period desc";
string rq = "";
/*
int tamt = 0;
string oem, baan, plant;
* */
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
//cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@period", period);
cmd.Parameters.AddWithValue("@oemid", oemid);
cmd.Parameters.AddWithValue("@project", project);
DataTable dt = db.getDataTableWithCmd(ref cmd);
cmd.Dispose();
rq = Multek.Util.DT2JSON(dt);
dt.Dispose();
}
return rq;
}
public void Update()
{
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_CusOEMUpdate");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CusOEM",CusOEM);
cmd.Parameters.AddWithValue("@BaanId", BaanId);
cmd.Parameters.AddWithValue("@salesmanId", salesmanId);
cmd.Parameters.AddWithValue("@OEMID", OEMID);
cmd.Parameters.AddWithValue("@isValid", isValid);
cmd.Parameters.AddWithValue("@viewSalesmanId", viewSalesmanId);
sqldb.execSqlWithCmd(ref cmd);
cmd.Dispose();
}
}
public string getUsers(string key)
{
string rq = "rs:{[]}";
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_gam_salesman_find";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@key", key);
DataTable dt = db.getDataTableWithCmd(ref cmd);
cmd.Dispose();
rq = Multek.Util.DT2JSON(dt);
}
return rq;
}
public static bool isCEMSales(string uid)
{
bool yes = false;
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("[sp_gam_isCEM_sales]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@usrid", uid);
yes = Convert.ToBoolean(sqldb.getSignalValueCmd(ref cmd));
cmd.Dispose();
}
return yes;
}
public static DataTable getsByManager(int manager_id)
{
DataTable dt = new DataTable();
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_salesmanGet");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@managerId", manager_id);
dt = sqldb.getDataTableWithCmd(ref cmd);
cmd.Dispose();
}
return dt;
}
public static void update(int manager_id, int sysUserId)
{
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("[sp_gam_salesmanChangeManager]");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@managerId", manager_id);
cmd.Parameters.AddWithValue("@sysId", sysUserId);
sqldb.execSqlWithCmd(ref cmd);
cmd.Dispose();
}
}
public void Add()
{
using (Multek.SqlDB sqldb = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_CusOEMAdd");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CusOEM", CusOEM);
cmd.Parameters.AddWithValue("@BaanId", BaanId);
cmd.Parameters.AddWithValue("@salesmanId", salesmanId);
cmd.Parameters.AddWithValue("@viewSalesmanId", viewSalesmanId);
SqlParameter par1 = cmd.Parameters.AddWithValue("@OEMID", 0);
par1.Direction = ParameterDirection.Output;
sqldb.execSqlWithCmd(ref cmd);
_OEMID = Convert.ToInt32(par1.Value);
cmd.Dispose();
}
}
public string getCusPartForecastUpdate(int period, int oemid, string customerPart, int amt,string cellid, bool resetTable)
{
int salesId = 0;
if (customerPart.IndexOf("<") >= 0 || customerPart.IndexOf(">") > 0)
{
return "obj = {cell:\"\",error:1,message:\"error, invalid part number!! "+ customerPart.Replace("\"","'") +"\"}";
}
if (HttpContext.Current.Session["usr"] != null)
{
nUser usr = (nUser)Session["usr"];
salesId = usr.sysUserId;
usr.Dispose();
}
int tamt = 0;
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_gam_forecastCustomerPart_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@period", period);
cmd.Parameters.AddWithValue("@oemid", oemid);
cmd.Parameters.AddWithValue("@project", customerPart);
cmd.Parameters.AddWithValue("@amt", amt);
cmd.Parameters.AddWithValue("@salesmanId", salesId);
SqlParameter _tamt = cmd.Parameters.AddWithValue("@tamt", 0);
_tamt.Direction = ParameterDirection.Output;
db.execSqlWithCmd(ref cmd);
tamt = Convert.ToInt32(_tamt.Value);
}
if (resetTable)
return GETFS(period, oemid);
else
return "obj = {\"amt\":\""+ amt.ToString() +"\",\"tamt\":\"" + tamt.ToString() +"\",\"cell\":\"" + cellid +"\"}";
}
public string getCusPartRemark(int oemid, string customerPart)
{
string remark = "{}";
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_gam_actualItemRemark_get";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@oemid", oemid);
cmd.Parameters.AddWithValue("@part_no", customerPart);
SqlParameter _rmk = cmd.Parameters.Add(new SqlParameter("@remark", SqlDbType.NVarChar, 1000));
_rmk.Direction = ParameterDirection.Output;
db.execSqlWithCmd(ref cmd);
cmd.Dispose();
remark = _rmk.Value.ToString().Replace(System.Environment.NewLine, "\\n ");
}
return remark;
}
public string getSale(string key)
{
DataTable dt;
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_gam_salesman_find";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@key", key);
cmd.Parameters.AddWithValue("@Salesonly", true);
dt = db.getDataTableWithCmd(ref cmd);
cmd.Dispose();
dt.Dispose();
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string json = jss.Serialize(dt);
return json;
}
public string getOEMComments(int oemid)
{
string author = "";
if (HttpContext.Current.Session["usr"] != null)
{
nUser usr = (nUser)Session["usr"];
author = usr.userName;
usr.Dispose();
}
string output = "";
using (Multek.SqlDB db = new Multek.SqlDB(__conn))
{
SqlCommand cmd = new SqlCommand("sp_gam_oem_comments_get");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@oem_id", oemid);
cmd.Parameters.AddWithValue("@author", author);
DataTable dt = db.getDataTableWithCmd(ref cmd);
cmd.Dispose();
output = Multek.Util.DT2JSON(dt);
}
return output;
}
