/// <summary>
/// 删除时上传工作人员信息
/// </summary>
/// <param name="deleteUser">要删除的人员信息</param>
void UploadUserData(List <string> DeleteUser)
{
DataTable dtuserinfo = dgvUser.DataSource as DataTable;
if (dtuserinfo != null)
{
Parallel.ForEach(DeleteUser, userid =>
{
DataRow[] druserinf = dtuserinfo.Select("user_id='" + userid + "'");
if (druserinf != null && druserinf.Length > 0)
{
var cont = new tb_contacts_ex();
cont.cont_id = userid; //id
cont.cont_name = CommonCtrl.IsNullToString(druserinf[0]["user_name"].ToString()); //name
cont.cont_post = CommonCtrl.IsNullToString(druserinf[0]["post"].ToString()); //post
cont.cont_phone = CommonCtrl.IsNullToString(druserinf[0]["user_phone"].ToString()); //phone
cont.nation = LocalCache.GetDictNameById(druserinf[0]["nation"].ToString());
cont.parent_customer = CommonCtrl.IsNullToString("");
cont.sex = UpSex(druserinf[0]["sex"].ToString()); //sex
//cont.status = CommonCtrl.IsNullToString(SYSModel.DataSources.EnumStatus.Start.ToString("d"));//status
cont.status = "1"; //status
cont.cont_post_remark = CommonCtrl.IsNullToString("");
cont.cont_crm_guid = CommonCtrl.IsNullToString(druserinf[0]["cont_crm_guid"].ToString()); //crmguid
cont.contact_type = "02";
DBHelper.WebServHandlerByFun("删除服务站工作人员", SYSModel.EnumWebServFunName.UpLoadCcontact, cont);
}
});
}
}
/// <summary>
/// 删除时上传工作人员信息
/// </summary>
/// <param name="deleteUser">要删除的人员信息</param>
void UploadUserData()
{
var cont = new tb_contacts_ex();
cont.cont_id = CommonCtrl.IsNullToString(userinfo["user_id"]); //id
cont.cont_name = CommonCtrl.IsNullToString(userinfo["user_name"].ToString()); //name
cont.cont_post = CommonCtrl.IsNullToString(userinfo["post"].ToString()); //post
cont.cont_phone = CommonCtrl.IsNullToString(userinfo["user_phone"].ToString()); //phone
cont.nation = LocalCache.GetDictNameById(userinfo["nation"].ToString());
cont.parent_customer = CommonCtrl.IsNullToString("");
cont.sex = UpSex(userinfo["sex"].ToString()); //sex
//cont.status = CommonCtrl.IsNullToString(SYSModel.DataSources.EnumStatus.Start.ToString("d"));//status
cont.status = "1"; //status
cont.cont_post_remark = CommonCtrl.IsNullToString("");
cont.cont_crm_guid = CommonCtrl.IsNullToString(userinfo["cont_crm_guid"].ToString()); //crmguid
cont.contact_type = "02";
DBHelper.WebServHandlerByFun("删除服务站工作人员", SYSModel.EnumWebServFunName.UpLoadCcontact, cont);
}
/// <summary>
/// 保存
/// </summary>
void UCPersonnelAddOrEdit_SaveEvent(object sender, EventArgs e)
{
string msg = string.Empty;
bool bln = Validator(ref msg);
if (!bln)
{
return;
}
string newGuid = string.Empty;
string currUser_id = "";
string keyName = string.Empty;
string keyValue = string.Empty;
string opName = "新增人员信息";
Dictionary <string, string> dicFileds = new Dictionary <string, string>();
dicFileds.Add("user_name", txtuser_name.Caption.Trim());//人员姓名
//账号
if (cbois_operator.SelectedValue.ToString() == DataSources.EnumYesNo.Yes.ToString("d"))
{
dicFileds.Add("land_name", txtland_name.Caption.Trim());
}
else
{
dicFileds.Add("land_name", "");
}
dicFileds.Add("user_phone", txtuser_phone.Caption.Trim()); //手机
dicFileds.Add("user_telephone", txtuser_telephone.Caption.Trim()); //固话
dicFileds.Add("org_id", txcorg_name.Tag.ToString().Trim()); //组织id
dicFileds.Add("sex", cbosex.SelectedValue.ToString()); //性别
dicFileds.Add("user_fax", txtuser_fax.Caption.Trim()); //传真
dicFileds.Add("is_operator", cbois_operator.SelectedValue.ToString()); //是否操作员
dicFileds.Add("idcard_type", cboidcard_type.SelectedValue.ToString()); //证件类型
dicFileds.Add("user_email", txtuser_email.Caption.Trim()); //邮箱
dicFileds.Add("idcard_num", txtidcard_num.Caption.Trim()); //证件号码
dicFileds.Add("user_address", txtuser_address.Caption.Trim()); //联系地址
dicFileds.Add("remark", txtremark.Caption.Trim()); //备注
//密码
if (cbois_operator.SelectedValue.ToString() == DataSources.EnumYesNo.Yes.ToString("d"))
{
dicFileds.Add("password", txtPassWord.Caption.Trim());
}
else
{
dicFileds.Add("password", "");//密码
}
dicFileds.Add("nation", cbonation.SelectedValue.ToString()); //民族
dicFileds.Add("graduate_institutions", txtgraduate_institutions.Caption.Trim()); //毕业学校
dicFileds.Add("technical_expertise", txttechnical_expertise.Caption.Trim()); //技术特长
dicFileds.Add("user_height", txtuser_height.Caption.Trim()); //身高
dicFileds.Add("native_place", txtnative_place.Caption.Trim()); //籍贯
dicFileds.Add("specialty", txtspecialty.Caption.Trim()); //专业
dicFileds.Add("entry_date", Common.LocalDateTimeToUtcLong(dtpentry_date.Value).ToString()); // 入职日期
dicFileds.Add("user_weight", txtuser_weight.Caption.Trim()); //体重
dicFileds.Add("register_address", txtregister_address.Caption.Trim()); //户籍所在地
dicFileds.Add("graduate_date", Common.LocalDateTimeToUtcLong(dtpgraduate_date.Value).ToString()); // 毕业时间
dicFileds.Add("wage", txtwage.Caption.Trim()); // 工资
dicFileds.Add("birthday", Common.LocalDateTimeToUtcLong(dtpbirthday.Value).ToString()); // 出生日期
dicFileds.Add("education", cboeducation.SelectedValue.ToString()); //学历
dicFileds.Add("position", cboposition.SelectedValue.ToString()); //岗位
dicFileds.Add("political_status", txtpolitical_status.Caption.Trim()); //政治面貌
dicFileds.Add("level", cbolevel.SelectedValue.ToString()); //级别
dicFileds.Add("health", cbojkzk.SelectedValue.ToString());//健康状况
string nowUtcTicks = Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString();
dicFileds.Add("update_by", HXCPcClient.GlobalStaticObj.UserID);
dicFileds.Add("update_time", nowUtcTicks);
string crmId = string.Empty;
if (wStatus == WindowStatus.Add || wStatus == WindowStatus.Copy)
{
dicFileds.Add("user_code", CommonUtility.GetNewNo(SYSModel.DataSources.EnumProjectType.User));//人员编码
newGuid = Guid.NewGuid().ToString();
currUser_id = newGuid;
dicFileds.Add("user_id", newGuid);//新ID
dicFileds.Add("create_by", HXCPcClient.GlobalStaticObj.UserID);
dicFileds.Add("create_time", nowUtcTicks);
dicFileds.Add("enable_flag", SYSModel.DataSources.EnumEnableFlag.USING.ToString("d")); //1为未删除状态
dicFileds.Add("status", SYSModel.DataSources.EnumStatus.Start.ToString("d")); //启用
dicFileds.Add("data_sources", Convert.ToInt16(SYSModel.DataSources.EnumDataSources.SELFBUILD).ToString()); //来源 自建
}
else if (wStatus == WindowStatus.Edit)
{
keyName = "user_id";
keyValue = id;
currUser_id = id;
newGuid = id;
crmId = dr["cont_crm_guid"].ToString();
opName = "更新人员管理";
}
bln = DBHelper.Submit_AddOrEdit(opName, "sys_user", keyName, keyValue, dicFileds);
string photo = string.Empty;
if (picuser.Tag != null)
{
photo = Guid.NewGuid().ToString() + Path.GetExtension(picuser.Tag.ToString());
if (!FileOperation.UploadFile(picuser.Tag.ToString(), photo))
{
return;
}
}
List <SQLObj> listSql = new List <SQLObj>();
listSql = AddPhoto(listSql, currUser_id, photo);
ucAttr.TableName = "sys_user";
ucAttr.TableNameKeyValue = currUser_id;
listSql.AddRange(ucAttr.AttachmentSql);
DBHelper.BatchExeSQLMultiByTrans(opName, listSql);
if (bln)
{
if (wStatus == WindowStatus.Add || wStatus == WindowStatus.Edit)
{
var cont = new tb_contacts_ex
{
cont_id = CommonCtrl.IsNullToString(newGuid), //id
cont_name = CommonCtrl.IsNullToString(this.txtuser_name.Caption.Trim()), //name
cont_post = CommonCtrl.IsNullToString(""), //post
cont_phone = CommonCtrl.IsNullToString(this.txtuser_phone.Caption.Trim()),
nation = CommonCtrl.IsNullToString(this.cbonation.SelectedValue.ToString()),
parent_customer = CommonCtrl.IsNullToString(""),
sex = UpSex(),
status = CommonCtrl.IsNullToString(SYSModel.DataSources.EnumStatus.Start.ToString("d")),
cont_post_remark = CommonCtrl.IsNullToString(""),
cont_crm_guid = CommonCtrl.IsNullToString(crmId),
contact_type = "02"
};
Update.BeginInvoke("上传服务站工作人员", SYSModel.EnumWebServFunName.UpLoadCcontact, cont, null, null);
//DBHelper.WebServHandlerByFun("上传服务站工作人员", SYSModel.EnumWebServFunName.UpLoadCcontact, cont);
}
if (this.RefreshDataStart != null)
{
this.RefreshDataStart();
}
LocalCache._Update(CacheList.User);
MessageBoxEx.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
deleteMenuByTag(this.Tag.ToString(), this.parentName);
}
else
{
MessageBoxEx.Show("保存失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
void UCCustomerAddOrEdit_SaveEvent(object sender, EventArgs e) //数据保存
{
try
{
if (!CheckControlValue())
{
return;
}
var sysSqlStrList = new List <SysSQLString>();
var custSql = BuildCustomerSqlString();
sysSqlStrList.Add(custSql.Item1);
sysSqlStrList.AddRange(BuildContactRelation(custSql.Item2));
sysSqlStrList.AddRange(BuildVehicleRelation(custSql.Item2));
sysSqlStrList.AddRange(BuildVipMemberSqlString(custSql.Item2));
//ucAttr.GetAttachmentSql(sysSqlStrList); //保存附件时失败...目前保留此代码
var opName = wStatus == WindowStatus.Edit ? "更新客户档案" : "新增客户档案";
var result = DBHelper.BatchExeSQLStringMultiByTrans(opName, sysSqlStrList);
if (result)
{
var customer = new tb_customer();
customer.cust_id = custSql.Item1.Param["cust_id"];
customer.cust_code = custSql.Item1.Param["cust_code"];
customer.cust_name = custSql.Item1.Param["cust_name"];
customer.cust_short_name = custSql.Item1.Param["cust_short_name"];
customer.cust_quick_code = custSql.Item1.Param["cust_quick_code"];
customer.cust_type = custSql.Item1.Param["cust_type"];
customer.legal_person = custSql.Item1.Param["legal_person"];
customer.enterprise_nature = custSql.Item1.Param["enterprise_nature"];
customer.cust_tel = custSql.Item1.Param["cust_tel"];
customer.cust_fax = custSql.Item1.Param["cust_fax"];
customer.cust_email = custSql.Item1.Param["cust_email"];
customer.cust_phone = custSql.Item1.Param["cust_phone"];
customer.cust_website = custSql.Item1.Param["cust_website"];
customer.province = custSql.Item1.Param["province"];
customer.city = custSql.Item1.Param["city"];
customer.county = custSql.Item1.Param["county"];
customer.cust_address = custSql.Item1.Param["cust_address"];
customer.zip_code = custSql.Item1.Param["zip_code"];
customer.tax_num = custSql.Item1.Param["tax_num"];
customer.indepen_legalperson = custSql.Item1.Param["indepen_legalperson"];
customer.credit_rating = custSql.Item1.Param["credit_rating"];
customer.credit_line = Convert.ToInt32(custSql.Item1.Param["credit_line"]);
customer.credit_account_period = Convert.ToInt32(custSql.Item1.Param["credit_account_period"]);
customer.price_type = custSql.Item1.Param["price_type"];
customer.billing_name = custSql.Item1.Param["billing_name"];
customer.billing_address = custSql.Item1.Param["billing_address"];
customer.billing_account = custSql.Item1.Param["billing_account"];
customer.open_bank = custSql.Item1.Param["open_bank"];
customer.bank_account = custSql.Item1.Param["bank_account"];
customer.bank_account_person = custSql.Item1.Param["bank_account_person"];
customer.cust_remark = custSql.Item1.Param["cust_remark"];
customer.is_member = custSql.Item1.Param["is_member"];
customer.member_number = custSql.Item1.Param["member_number"];
customer.member_class = custSql.Item1.Param["member_class"];
if (rdbis_member_y.Checked)
{
customer.member_period_validity = Convert.ToInt64(custSql.Item1.Param["member_period_validity"]);
}
customer.status = custSql.Item1.Param["status"];
customer.enable_flag = custSql.Item1.Param["enable_flag"];
customer.data_source = custSql.Item1.Param["data_source"];
customer.cust_crm_guid = custSql.Item1.Param["cust_crm_guid"];
customer.accessories_discount = 0;
customer.workhours_discount = 0;
customer.country = custSql.Item1.Param["country"];
customer.indepen_legalperson = custSql.Item1.Param["indepen_legalperson"];
customer.market_segment = custSql.Item1.Param["market_segment"];
customer.institution_code = custSql.Item1.Param["institution_code"];
customer.com_constitution = custSql.Item1.Param["com_constitution"];
customer.registered_capital = custSql.Item1.Param["registered_capital"];
customer.vehicle_structure = custSql.Item1.Param["vehicle_structure"];
customer.agency = custSql.Item1.Param["agency"];
customer.sap_code = custSql.Item1.Param["sap_code"];
customer.business_scope = custSql.Item1.Param["business_scope"];
customer.ent_qualification = custSql.Item1.Param["ent_qualification"];
if (wStatus == WindowStatus.Edit)
{
customer.update_by = custSql.Item1.Param["update_by"];
customer.update_time = Convert.ToInt64(custSql.Item1.Param["update_time"]);
}
else
{
customer.create_time = Convert.ToInt64(custSql.Item1.Param["create_time"]);
customer.create_by = custSql.Item1.Param["create_by"];
}
var flag = DBHelper.WebServHandler(opName, EnumWebServFunName.UpLoadCustomer, customer);
if (String.IsNullOrEmpty(flag))
{
var contactSql = BuildContactRelation(custSql.Item2).ToArray();
foreach (var sysSqlString in contactSql)
{
if (!sysSqlString.Param.ContainsKey("cont_id"))
{
continue;
}
var contId = sysSqlString.Param["cont_id"];
var dt1 = DBHelper.GetTable("获取客户CRMID", "tb_customer", "*", String.Format("cust_id = '{0}'", customer.cust_id), "", "");
var dt = DBHelper.GetTable("根据客户档案获取联系信息", "v_contacts", string.Format("*,{0} phone", EncryptByDB.GetDesFieldValue("cont_phone")), " cont_id = '" + contId + "'", "", "");
if (dt.DefaultView != null && dt.DefaultView.Count > 0)
{
var cont = new tb_contacts_ex
{
cont_id = CommonCtrl.IsNullToString(dt.DefaultView[0]["cont_id"]),
cont_name = CommonCtrl.IsNullToString(dt.DefaultView[0]["cont_name"]),
cont_post = CommonCtrl.IsNullToString(dt.DefaultView[0]["cont_post_name"]),
cont_phone = CommonCtrl.IsNullToString(dt.DefaultView[0]["phone"]),
nation = CommonCtrl.IsNullToString(dt.DefaultView[0]["nation_name"]),
parent_customer = CommonCtrl.IsNullToString(dt1.DefaultView[0]["cust_crm_guid"]),
//alter by 杨超逸
//2014.12.26
//宇通借口男女性别上传数据修改联系人时,性别传1（男）和2（女）
//sex = CommonCtrl.IsNullToString(dt.DefaultView[0]["sex"]),
sex = UpSex(dt.DefaultView[0]["sex"]),
//alter end
status = CommonCtrl.IsNullToString(dt.DefaultView[0]["status"]),
cont_post_remark = CommonCtrl.IsNullToString(dt.DefaultView[0]["post_remark"]),
cont_crm_guid = CommonCtrl.IsNullToString(dt.DefaultView[0]["cont_crm_guid"]),
contact_type = "01" //标识类型为联系人
};
var flag4Cont = DBHelper.WebServHandler(opName, EnumWebServFunName.UpLoadCcontact, cont);
if (String.IsNullOrEmpty(flag4Cont))
{
//do something
}
}
}
}
MessageBoxEx.Show("保存成功!", "保存");
UCCustomerManager.BindPageData();
deleteMenuByTag(Tag.ToString(), UCCustomerManager.Name);
}
else
{
MessageBoxEx.Show("保存失败!", "保存");
}
}
catch (Exception ex)
{
MessageBoxEx.Show("保存失败！" + ex.Message, "提示");
}
}
/// <summary> 根据EnumWebServFunName枚举，调用WebService方法名称
/// </summary>
/// <param name="funcName">WebService方法名称</param>
/// <param name="funcObject">WebService参数对象</param>
/// <returns>返回约定内容</returns>
public static SYSModel.RespFunStruct WebServHandler(SYSModel.EnumWebServFunName enumFunName, object funcObject)
{
SYSModel.RespFunStruct resp = new SYSModel.RespFunStruct();
string msg = string.Empty;//错误消息
switch (enumFunName)
{
#region 基础数据
case SYSModel.EnumWebServFunName.UpLoadCcontact:
{
tb_contacts_ex model = Newtonsoft.Json.JsonConvert.DeserializeObject <tb_contacts_ex>(funcObject.ToString());
string result = WebServ_YT_BasicData.UpLoadCcontact(model);
resp = HandleErr(string.IsNullOrEmpty(result) ? "1" : "0", result);
break;
}
case SYSModel.EnumWebServFunName.UpLoadCustomer:
{
tb_customer model = Newtonsoft.Json.JsonConvert.DeserializeObject <tb_customer>(funcObject.ToString());
string result = WebServ_YT_BasicData.UpLoadCustomer(model);
resp = HandleErr(string.IsNullOrEmpty(result) ? "1" : "0", result);
break;
}
case SYSModel.EnumWebServFunName.UpLoadSercicePartStock:
{
Dictionary <string, int> dic = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, int> >(funcObject.ToString());
bool flag = WebServ_YT_BasicData.UpLoadSercicePartStock(dic);
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.SearchContact:
{
DataTable dt = WebServ_YT_BasicData.SearchContact();
if (dt == null || dt.Rows.Count == 0)
{
resp.IsSuccess = "0";
}
else
{
resp.IsSuccess = "1";
}
resp.Msg = "";
resp.ReturnObject = Newtonsoft.Json.JsonConvert.SerializeObject(dt);
break;
}
#endregion
#region 业务数据
case SYSModel.EnumWebServFunName.UpLoadPartSale:
{
bool flag = WebServ_YT_BusiData.UpLoadPartSale(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.UpLoadServiceOrder:
{
bool flag = WebServ_YT_BusiData.UpLoadServiceOrder(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.UpLoadRepairBill:
{
bool flag = WebServ_YT_BusiData.UpLoadRepairBill(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.UpLoadPartPurchase:
{
bool flag = WebServ_YT_BusiData.UpLoadPartPurchase(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.UpLoadPartPutStore:
{
bool flag = WebServ_YT_BusiData.UpLoadPartPutStore(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.LoadOrderStatus:
{
bool flag = WebServ_YT_BusiData.LoadOrderStatus(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.LoadPartInStore:
{
bool flag = WebServ_YT_BusiData.LoadPartInStore(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.LoadPartPurchaseStauts:
{
bool flag = WebServ_YT_BusiData.LoadPartPurchaseStauts(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.LoadStoreCenter:
{
bool flag = WebServ_YT_BusiData.LoadStoreCenter(funcObject.ToString());
resp = HandleErr(flag ?"1":"0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.QuerySettleAccounts:
{
bool flag = WebServ_YT_BusiData.QuerySettleAccounts(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.LoadServiceSettleStatus:
{
bool flag = WebServ_YT_BusiData.LoadServiceSettleStatus(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.UpPartReturnCreate:
{
bool flag = WebServ_YT_BusiData.UpPartReturnCreate(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.LoadPartRetureStatus:
{
bool flag = WebServ_YT_BusiData.LoadPartRetureStatus(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case SYSModel.EnumWebServFunName.UpPartRetureUpdate:
{
bool flag = WebServ_YT_BusiData.UpPartRetureUpdate(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
case EnumWebServFunName.SearchOrderStatus:
{
string status = WebServ_YT_BusiData.SearchOrderStatus(funcObject.ToString());
resp = HandleErr(string.IsNullOrEmpty(status) ? "0" : "1", status);
break;
}
case EnumWebServFunName.UpLoadServiceSettleStatus:
{
bool flag = WebServ_YT_BusiData.UpLoadServiceSettleStatus(funcObject.ToString());
resp = HandleErr(flag ? "1" : "0", flag.ToString());
break;
}
#endregion
default:
{
resp.IsSuccess = "0";
resp.Msg = "找不到对应的Wcf方法";
break;
}
}
return(resp);
}
