/// <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); } }