/// <summary>
/// 删除表,列
/// </summary>
public string DeletetableFiled(string Id, int UserId)
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
try
{
int Ids = Convert.ToInt32(Id);
var p = (from c in context.tableFiledPerssion where c.Id == Ids select c).First();
var cp = (from c in context.tableFiledPerssion where c.Id == Ids select c).FirstOrDefault();
if (cp.tableLevel == 0)
{
var ps = from c in context.tableFiledPerssion where c.tableLevel == cp.Id select c;
foreach (var item in ps)
{
context.tableFiledPerssion.DeleteOnSubmit(item);
}
context.tableFiledPerssion.DeleteOnSubmit(p);
context.SubmitChanges();
errordal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->tablefiledPerssiondal->DeletetableFiled()",
ErrorMsg = "删除",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "删除表->" + cp.tableName,
UserId = UserId,
});
return("");
}
else
{
context.tableFiledPerssion.DeleteOnSubmit(p);
context.SubmitChanges();
errordal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->tablefiledPerssiondal->DeletetableFiled()",
ErrorMsg = "删除",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "删除列->" + p.tableName,
UserId = UserId,
});
return("");
}
}
catch (Exception ex)
{
errordal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->tablefiledPerssiondal->DeletetableFiled()",
ErrorMsg = "删除",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = "删除表或列->" + ex.Message,
UserId = UserId,
});
return("删除失败!");
}
}
/// <summary>
/// 修改发送订单状态(是否开放给供应商查看,0为未开放，1为开放)
/// </summary>
/// <returns></returns>
public string updateParentShowOrderState(string orderId)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
try
{
var p = from c in context.apiSendOrder where c.orderId == orderId select c;
foreach (var q in p)
{
if (q.showStatus >= 1)
{
return("订单已开发,请勿重复操作");
}
q.showStatus = 1;
}
//p.showStatus = 1;
//context.apiSendOrder.Attach(p);
context.SubmitChanges();
s = "开放成功";
}
catch { s = "开放失败"; }
return(s);
}
/// <summary>
/// 添加客户端用户信息
/// </summary>
public string AddClientUsers(string UserName, string PassWord, string Vencode, string Email)
{
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var q = context.ClientLogin.Where(a => a.userName == UserName);
if (q.ToList().Count > 0)
{
return("该用户已存在!");
}
model.ClientLogin CL = new model.ClientLogin()
{
userName = UserName,
userPwd = PassWord,
sourceId = Convert.ToInt32(Vencode),
Def1 = Email,
};
context.ClientLogin.InsertOnSubmit(CL);
context.SubmitChanges();
return("添加成功!");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 删除日志信息
/// </summary>
/// <param name="id">日志id</param>
public bool DeleteErrorlog(int id, out string mess)
{
mess = "";
try
{
pbx = new model.pbxdatasourceDataContext(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
pbx.Connection.Open();
var temp = from c in pbx.errorlog where c.Id == id select c;
if (temp.ToList().Count == 0)
{
mess = "该条信息已经不存在";
return(false);
}
pbx.errorlog.DeleteAllOnSubmit(temp);
pbx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
pbx.Connection.Close();
}
}
/// <summary>
/// 复制角色权限
/// </summary>
public string CopyUsers(string Id, string PersonaId)
{
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
string sql = string.Empty;
DataTable dt = new DataTable();
var q = from c in context.personapermisson where c.personaId == Convert.ToInt32(Id) select c;
foreach (var item in q)
{
var person = new model.personapermisson()
{
personaId = Convert.ToInt32(PersonaId),
MemuId = item.MemuId,
FunId = item.FunId,
FieldId = item.FieldId
};
context.personapermisson.InsertOnSubmit(person);
//sql = @"insert into personapermisson(personaId,MemuId,FunId,FieldId) values(" + Id + "," + item.MemuId + "," + Convert.ToInt32(item.FunId == null ? 0 : item.FunId) + "," + Convert.ToInt32(item.FieldId == null ? 0 : item.FieldId) + ")";
//DbHelperSQL.ExecuteSql(sql);
}
context.SubmitChanges();
return("复制成功!");
}
catch (Exception ex)
{
return("复制失败!");
}
}
/// <summary>
/// 取消订单(1待确认，2确认，3待发货，4发货，5收货(交易成功)，11退货，12取消)
/// </summary>
/// <param name="orderId">订单ID</param>
/// <param name="o">实体连接</param>
/// <returns></returns>
public string cancelOrder(string orderId, object o)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = (model.pbxdatasourceDataContext)o;
try
{
var p = (from c in context.apiSendOrder where c.orderId == orderId select c).FirstOrDefault(); //供应商订单表
if (p != null)
{
p.newStatus = 12;
}
var p1 = (from c in context.apiOrderDetails where c.orderId == orderId select c).FirstOrDefault(); //子订单表
if (p1 != null)
{
p1.detailsStatus = 12;
}
var p2 = (from c in context.apiOrder where c.orderId == orderId select c).FirstOrDefault(); //主订单表
if (p2 != null)
{
p2.orderStatus = 12;
}
context.SubmitChanges();
s = "取消成功";
}
catch (Exception ex) { s = "取消失败(" + ex.Message + ")"; }
return(s);
}
/// <summary>
/// 添加退款操作记录
/// </summary>
/// <param name="mm"></param>
public void OperaRecord(model.OperationRecord mm)
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
mm.OperaTime = DateTime.Now;
context.OperationRecord.InsertOnSubmit(mm);
context.SubmitChanges();
}
/// <summary>
/// 更新订单支付报关
/// </summary>
/// <param name="payResult"></param>
/// <returns></returns>
public string updatePayCustoms(model.payCustomsResult payResult)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var p = (from c in context.payCustomsResult where c.OrderChildId == payResult.OrderChildId select c).SingleOrDefault();
p.OrderChildId = payResult.OrderChildId;
p.error = payResult.error; //错误信息
p.result_code = payResult.result_code; //响应码(处理结果响应码。SUCCESS：成功,FAIL：失败)
p.trade_no = payResult.trade_no; //支付宝交易号(该交易在支付宝系统中的交易流水号。最长 64 位。)
p.alipay_declare_no = payResult.alipay_declare_no; //支付宝报关流水号(支付宝报关流水号)
p.isSuccess = ""; //请求是否成功请求是否成功。请求成功不代表业务处理成功。(T代表成功,F代表失败)
try
{
context.SubmitChanges();
s = "更新支付成功";
}
catch (Exception ex)
{
s = "更新支付失败(" + ex.Message + ")";
}
return(s);
}
/// <summary>
/// 更新报文状态(商检审核--更新数据表)
/// </summary>
/// <param name="resultStatus"></param>
/// <returns></returns>
public string updateUploadStatus1(model.productCustomsResult resultStatus)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var p = (from c in context.productCustomsResult where c.productScode == resultStatus.productScode select c).SingleOrDefault();
if (p == null)
{
return("货号为" + resultStatus.productScode + "的商品未生成过报文");
}
p.CIQGoodsNO = resultStatus.CIQGoodsNO;
p.RegStatus = resultStatus.RegStatus;
p.RegNotes = resultStatus.RegNotes;
try
{
context.SubmitChanges();
s = "更新商检成功";
}
catch (Exception ex)
{
s = ex.Message;
//s = "更新商检失败";
}
return(s);
}
/// <summary>
/// 取消订单(1待确认，2确认，3待发货，4发货，5收货(交易成功)，11退货，12取消)
/// </summary>
/// <param name="scode">货号</param>
/// <param name="localBanlace">本次购买数量</param>
/// <param name="o">实体连接</param>
/// <returns></returns>
public string minusBanlace(string scode, int localBanlace, object o)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = (model.pbxdatasourceDataContext)o;
model.product MdProduct = (from c in context.product where c.Scode == scode select c).FirstOrDefault();
if (MdProduct != null && MdProduct.Def3 > 0)
{
MdProduct.Scode = scode;
MdProduct.Def3 = MdProduct.Def3 - localBanlace;
context.SubmitChanges();
s = "减去销售数量成功";
}
else
{
s = "减去销售数量失败";
}
}
catch (Exception ex)
{
s = "减去销售数量失败" + (ex.Message);
}
return(s);
}
/// <summary>
/// 修改店铺天猫订单数据(子订单)
/// </summary>
/// <returns></returns>
public string updateChildTmallOrder(string OrderChildenId, decimal DetailsPrice, DateTime orderSendTime, DateTime orderSucessTime)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
model.OrderDetails p = (from c in context.OrderDetails where c.OrderId == OrderChildenId select c).FirstOrDefault();
if (p != null)
{
p.DetailsPrice = DetailsPrice;
if (!string.IsNullOrWhiteSpace(orderSendTime.ToString()) && orderSendTime.ToString() != "0001-01-01 00:00:00")
{
p.OrderSendTime = orderSendTime;
}
if (!string.IsNullOrWhiteSpace(orderSucessTime.ToString()) && orderSucessTime.ToString() != "0001-01-01 00:00:00")
{
p.OrderSucessTime = orderSucessTime;
}
context.SubmitChanges();
s = "更新成功！";
}
}
catch (Exception ex)
{
s = "更新失败！";
}
return(s);
}
public bool DeleteCustomProperty(int id, out string mess)
{
mess = "";
try
{
pbx = new model.pbxdatasourceDataContext(connectionString);
pbx.Connection.Open();
var temp = from c in pbx.CustomProperty where id == c.Id select c;
if (temp.ToList().Count > 0)
{
pbx.CustomProperty.DeleteAllOnSubmit(temp);
pbx.SubmitChanges();
return(true);
}
else
{
mess = "该信息已经不存在！";
return(false);
}
}
catch (Exception ex)
{
mess = ex.ToString();
return(false);
}
finally
{
pbx.Connection.Close();
}
}
/// <summary>
/// 更新报文状态(联邦--更新数据表)
/// </summary>
/// <param name="resultStatus"></param>
/// <returns></returns>
public string updateUploadStatus2(model.orderCustomsResult resultStatus)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var p = (from c in context.orderCustomsResult where c.SJOrgOrderChildId == resultStatus.SJOrgOrderChildId select c).SingleOrDefault();
if (p == null)
{
return("更新联邦失败,无订单(" + resultStatus.SJOrgOrderChildId + ")信息记录");
}
//BBCReturnData,BBCask,BBCmessage,BBCorderCode,BBCerrorMessage,BBCstatus
p.BBCReturnData = resultStatus.BBCReturnData;
p.BBCask = resultStatus.BBCask;
p.BBCmessage = resultStatus.BBCmessage;
p.BBCorderCode = resultStatus.BBCorderCode;
p.BBCerrorMessage = resultStatus.BBCerrorMessage;
p.BBCstatus = resultStatus.BBCstatus;
try
{
context.SubmitChanges();
s = "更新联邦成功";
}
catch
{
s = "更新联邦失败";
}
return(s);
}
public string insert_L(object o)
{
string s = string.Empty;
model.mytest_L MDmytest = new model.mytest_L();
model.pbxdatasourceDataContext context = (model.pbxdatasourceDataContext)o;
///model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var p = (from c in context.apiOrder where c.orderId == "212" select c).FirstOrDefault().def3;
try
{
MDmytest.uname = "张三";
MDmytest.upwd = "123456";
MDmytest.usex = "男";
context.mytest_L.InsertOnSubmit(MDmytest);
context.SubmitChanges();
s = "添加成功";
}
catch (Exception ex)
{
s = "添加失败(" + ex.Message + ")";
}
return(s);
}
/// <summary>
///添加表
/// </summary>
/// <returns></returns>
public string AddTabName(string tableName, int UserId)
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
try
{
string check = @"select count(*) from syscolumns where id=object_id('" + tableName + "')";
if (DbHelperSQL.Query(check).Tables[0].Rows[0][0].ToString() == "0")
{
return("该表不存在!");
}
else
{
var p = (from c in context.tableFiledPerssion where c.tableName == tableName select c.tableName).FirstOrDefault();
if (p == null)
{
model.tableFiledPerssion tt = new model.tableFiledPerssion()
{
tableName = tableName,
tableLevel = 0,
tableNameState = 1,
tableFiledState = 1,
};
context.tableFiledPerssion.InsertOnSubmit(tt);
context.SubmitChanges();
string sql = @"insert into tableFiledPerssion(tableName,tableLevel) select name,(select id from tableFiledPerssion where tableName='" + tableName + "') from sys.syscolumns where id =object_id('" + tableName + "')";
DbHelperSQL.ExecuteSql(sql);
errordal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->tablefiledPerssiondal->AddTabName()",
ErrorMsg = "添加",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "添加表->" + tableName,
UserId = UserId,
});
}
else
{
return("该表已存在!");
}
return("");
}
}
catch (Exception ex)
{
errordal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->tablefiledPerssiondal->AddTabName()",
ErrorMsg = "添加",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = "添加表失败->" + tableName + "->" + ex.Message,
UserId = UserId,
});
return("添加失败!");
}
}
/// <summary>
/// 分配角色的菜单权限
/// </summary>
/// <param name="mdRole"></param>
/// <returns></returns>
public string AddRolePersonapermisson(List <model.personapermisson> list)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(Maticsoft.DBUtility.PubConstant.ConnectionString);
try
{
context.personapermisson.InsertAllOnSubmit(list);
context.SubmitChanges();
s = "分配权限成功";
}
catch { s = "分配权限失败"; }
return(s);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="Code"></param>
/// <param name="exx"></param>
/// <returns></returns>
public bool DeleteProductsources(string Code, out Exception exx)
{
System.Data.Common.DbTransaction tran = null;
try
{
OpenCon();
tran = pbx.Connection.BeginTransaction();
pbx.Transaction = tran;
var config = from c in pbx.productsourceConfig where c.SourceCode == Code select c;
var temp = from c in pbx.productsource where c.SourceCode == Code select c;
foreach (var c in config)
{
pbx.productsourceConfig.DeleteOnSubmit(c);
}
foreach (var t in temp)
{
pbx.productsource.DeleteOnSubmit(t);
}
pbx.SubmitChanges();
tran.Commit();
exx = null;
return(true);
}
catch (Exception ex)
{
if (tran != null)
{
tran.Rollback();
}
exx = ex;
return(false);
}
finally
{
CloseCon();
}
}
/// <summary>
/// 更新用户
/// </summary>
/// <returns></returns>
public string UpdateUserInfo(Dictionary <string, string> Dic)
{
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var q = from c in context.users where c.userName == Dic["UserName"] && c.userPwd == Dic["oldPwd"] select c;
if (q.FirstOrDefault() != null)
{
foreach (var item in q)
{
item.userRealName = Dic["RealName"];
item.userSex = Convert.ToInt32(Dic["sex"]);
item.userPwd = Dic["Pwd"];
item.UserPhone = Dic["Phone"];
item.UserEmail = Dic["Email"];
item.UserAddress = Dic["Address"];
}
context.SubmitChanges();
errordal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->usersdal->UpdateUserInfo()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "修改个人信息->" + Dic["UserName"],
UserId = Convert.ToInt32(Dic["UserId"].ToString())
});
return("修改成功!");
}
else
{
return("密码错误!");
}
}
catch (Exception ex)
{
errordal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->usersdal->UpdateUserInfo()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = Convert.ToInt32(Dic["UserId"].ToString())
});
return("修改失败!");
}
}
/// <summary>
/// 上传报文状态(插入数据表)
/// </summary>
/// <param name="resultStatus"></param>
/// <returns></returns>
public string addUploadStatus(model.orderCustomsResult resultStatus)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
try
{
context.orderCustomsResult.InsertOnSubmit(resultStatus);
context.SubmitChanges();
s = "添加成功";
}
catch {
s = "添加失败";
}
return(s);
}
/// <summary>
/// 修改店铺天猫订单数据(主订单)
/// </summary>
/// <returns></returns>
public string updateTmallOrder(string orderId, decimal orderPrice, DateTime orderTime, DateTime orderPayTime, DateTime orderEditTime, DateTime orderSendTime, DateTime orderSucessTime, int payState, int orderState, int orderState1)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
model.porder p = (from c in context.porder where c.OrderId == orderId select c).FirstOrDefault();
if (p != null)
{
p.OrderTime = orderTime;
p.OrderPrice = orderPrice;
if (!string.IsNullOrWhiteSpace(orderTime.ToString()))
{
p.OrderTime = orderTime;
}
if (!string.IsNullOrWhiteSpace(orderPayTime.ToString()) && orderPayTime.ToString() != "0001-01-01 00:00:00")
{
p.OrderPayTime = orderPayTime;
}
if (!string.IsNullOrWhiteSpace(orderEditTime.ToString()) && orderEditTime.ToString() != "0001-01-01 00:00:00")
{
p.OrderEditTime = orderEditTime;
}
if (!string.IsNullOrWhiteSpace(orderSendTime.ToString()) && orderSendTime.ToString() != "0001-01-01 00:00:00")
{
p.OrderSendTime = orderSendTime;
}
if (!string.IsNullOrWhiteSpace(orderSucessTime.ToString()) && orderSucessTime.ToString() != "0001-01-01 00:00:00")
{
p.OrderSucessTime = orderSucessTime;
}
p.PayState = payState;
p.OrderState = orderState;
p.OrderState1 = orderState1;
context.SubmitChanges();
s = "更新成功！";
}
}
catch (Exception ex)
{
s = "更新失败！";
}
return(s);
}
/// <summary>
/// 添加错误日志信息
/// </summary>
/// <param name="list">错误日志实体集合</param>
public void InsertErrorlogList(List <model.errorlog> list)
{
try
{
pbx = new model.pbxdatasourceDataContext(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
pbx.Connection.Open();
pbx.errorlog.InsertAllOnSubmit(list);
pbx.SubmitChanges();
}
catch (Exception ex)
{
}
finally
{
pbx.Connection.Close();
}
}
/// <summary>
/// 插入订单支付报关
/// </summary>
/// <param name="payResult"></param>
/// <returns></returns>
public string addPayCustoms(model.payCustomsResult payResult)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
try
{
context.payCustomsResult.InsertOnSubmit(payResult);
context.SubmitChanges();
s = "添加成功";
}
catch (Exception ex)
{
s = "添加失败(" + ex.Message + ")";
}
return(s);
}
public void insert()
{
pbx = new model.pbxdatasourceDataContext(connectionString);
pbx.Connection.Open();
for (int i = 0; i < 1000; i++)
{
model.CustomProperty customPro = new model.CustomProperty();
Random ran = new Random();
customPro.CustomId = ran.Next(19, 22);
customPro.CustomLevel = ran.Next(0, 5).ToString();
customPro.CustomBuyCount = ran.Next(1000);
customPro.CustomBuyAmount = ran.Next(1000000);
customPro.CustomLoveBrand = "阿道夫" + i + "打" + i;
customPro.CustomServiceComment = "好︿(￣︶￣)︿︿(￣︶￣)︿";
pbx.CustomProperty.InsertOnSubmit(customPro);
}
pbx.SubmitChanges();
}
/// <summary>
/// 删除用户
/// </summary>
/// <returns></returns>
public string del(int id)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
model.menu p = (from c in context.menu where c.Id == id select c).FirstOrDefault();
context.menu.DeleteOnSubmit(p);
context.SubmitChanges();
s = "删除成功！";
}
catch (Exception ex)
{
s = "删除失败！";
}
return(s);
}
/// <summary>
/// 删除客户端用户
/// </summary>
public string DeleteClientUsers(string UserName)
{
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var q = context.ClientLogin.Where(a => a.userName == UserName);
foreach (var i in q)
{
context.ClientLogin.DeleteOnSubmit(i);
}
context.SubmitChanges();
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 修改表名,列名
/// </summary>
public string UpdateTabName(string Id, string TabName)
{
try
{
int nid = Convert.ToInt32(Id);
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var p = (from c in context.tableFiledPerssion where c.Id == nid select c);
foreach (var item in p)
{
item.tableName = TabName;
}
context.SubmitChanges();
return("");
}
catch (Exception ex)
{
return("修改失败!");
}
}
/// <summary>
/// 取消订单(1待确认，2确认，3待发货，4发货，5收货(交易成功)，11退货，12取消)
/// </summary>
/// <param name="orderId"></param>
/// <returns></returns>
public string cancelParentOrder(string orderId)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
try
{
var p = from c in context.apiSendOrder where c.orderId == orderId select c; //供应商订单表
foreach (var q in p)
{
if (q.newStatus >= 12)
{
return("取消已被订单,请勿重复操作");
}
q.newStatus = 12;
}
var p1 = from c in context.apiOrderDetails where c.orderId == orderId select c; //子订单表
foreach (var q1 in p1)
{
if (q1.detailsStatus >= 12)
{
return("取消已被订单,请勿重复操作");
}
q1.detailsStatus = 12;
}
var p2 = from c in context.apiOrder where c.orderId == orderId select c; //主订单表
foreach (var q2 in p2)
{
if (q2.orderStatus >= 12)
{
return("取消已被订单,请勿重复操作");
}
q2.orderStatus = 12;
}
context.SubmitChanges();
s = "取消成功";
}
catch { s = "取消失败"; }
return(s);
}
/// <summary>
/// 根据子订单更新联邦订单报备
/// </summary>
/// <param name="orderChildId">子订单ID</param>
/// <param name="status">更改状态</param>
/// <returns></returns>
public string UpdateBBCStates(string orderChildId, string status)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var p = (from c in context.apiSendOrder where c.detailsOrderId == orderChildId select c).SingleOrDefault();
p.def3 = status;
try
{
context.SubmitChanges();
s = "更新成功";
}
catch
{
s = "更新失败";
}
return(s);
}
/// <summary>
/// 订单状态更改为待发货状态(订单当前状态：0为待确认，1为有货，2为缺货，3为发货，4为取消订单，5交易成功，6通关异常，7，通关成功，11退货，12取消)
/// </summary>
/// <param name="orderId"></param>
/// <returns></returns>
public string updateSendOrderState(string orderId)
{
string s = string.Empty;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
try
{
var p = (from c in context.apiSendOrder where c.orderId == orderId select c).FirstOrDefault(); //供应商订单表
p.newStatus = 3;
var p1 = (from c in context.apiOrderDetails where c.orderId == orderId select c).FirstOrDefault(); //子订单表
p1.detailsStatus = 3;
var p2 = (from c in context.apiOrder where c.orderId == orderId select c).FirstOrDefault(); //主订单表
p2.orderStatus = 3;
context.SubmitChanges();
s = "更改成功";
}
catch { s = "更改失败"; }
return(s);
}
/// <summary>
/// 修改客户端用户信息
/// </summary>
public string UpdateClientUsers(string UserName, string PassWord, string Vencode, string Email)
{
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var q = context.ClientLogin.Where(a => a.userName == UserName);
foreach (var i in q)
{
i.userPwd = PassWord;
i.sourceId = Convert.ToInt32(Vencode);
i.Def1 = Email;
}
context.SubmitChanges();
return("修改成功!");
}
catch (Exception ex)
{
return(ex.Message);
}
}
