public string AddInnerCustomer(Model.manager model, SqlConnection conn, SqlTransaction trans)
{
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select count(*) from ms_customer where c_name=@name and c_type=3");
SqlParameter[] pa = new SqlParameter[] {
new SqlParameter("@name", SqlDbType.VarChar, 50)
};
pa[0].Value = "员工-" + model.real_name + "(" + model.user_name + ")";
int obj = Convert.ToInt32(DbHelperSQL.GetSingle(conn, trans, strSql1.ToString(), pa));
if (obj == 0)
{
Model.Customer cu = new Model.Customer();
cu.c_name = "员工-" + model.real_name + "(" + model.user_name + ")";
cu.c_type = 3;
cu.c_flag = 2;
cu.c_isUse = true;
cu.c_owner = model.user_name;
cu.c_ownerName = model.real_name;
cu.c_addDate = DateTime.Now;
Model.Contacts co = new Model.Contacts();
co.co_flag = true;
co.co_name = model.real_name;
co.co_number = model.telephone;
int cid = 0;
return(new DAL.Customer().insertData(cu, co, conn, trans, out cid));
}
return("");
}
/// <summary>
///
/// </summary>
/// <param name="strWhere"></param>
/// <param name="filedOrder"></param>
/// <returns></returns>
public List <Model.Contacts> getList(string strWhere, string filedOrder)
{
string sql = "select * from MS_Contacts ";
if (!string.IsNullOrEmpty(strWhere))
{
sql += " where " + strWhere;
}
if (!string.IsNullOrEmpty(filedOrder))
{
sql += " order by " + filedOrder;
}
List <Model.Contacts> list = new List <Model.Contacts>();
Model.Contacts model = null;
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
model = new Model.Contacts();
model.co_id = Convert.ToInt32(sdr["co_id"]);
model.co_cid = Convert.ToInt32(sdr["co_cid"]);
model.co_flag = Convert.ToBoolean(sdr["co_flag"]);
model.co_name = sdr["co_name"].ToString();
model.co_number = sdr["co_number"].ToString();
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 添加内部客户
/// </summary>
/// <param name="username"></param>
/// <param name="manager"></param>
/// <returns></returns>
public string AddInnerCustomer(string username, Model.manager manager)
{
Model.manager model = new BLL.manager().GetModel(username);
if (model == null)
{
return("用户不存在");
}
Model.Customer cu = new Model.Customer();
cu.c_name = "员工-" + model.real_name + "(" + model.user_name + ")";
cu.c_type = 3;
cu.c_flag = 2;
cu.c_isUse = true;
cu.c_owner = model.user_name;
cu.c_ownerName = model.real_name;
cu.c_addDate = DateTime.Now;
Model.Contacts co = new Model.Contacts();
co.co_flag = true;
co.co_name = model.real_name;
co.co_number = model.telephone;
int cid = 0;
return(Add(cu, co, manager, out cid));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Contacts model, SqlConnection conn = null, SqlTransaction tran = null)
{
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder();
//利用反射获得属性的所有公共属性
PropertyInfo[] pros = model.GetType().GetProperties();
List <SqlParameter> paras = new List <SqlParameter>();
strSql.Append("update MS_Contacts set ");
foreach (PropertyInfo pi in pros)
{
//如果不是主键则追加sql字符串
if (!pi.Name.Equals("co_id"))
{
//判断属性值是否为空
if (pi.GetValue(model, null) != null)
{
str1.Append(pi.Name + "=@" + pi.Name + ","); //声明参数
paras.Add(new SqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值
}
}
}
strSql.Append(str1.ToString().Trim(','));
strSql.Append(" where co_id=@id ");
paras.Add(new SqlParameter("@id", model.co_id));
if (tran == null)
{
return(DbHelperSQL.ExecuteSql(strSql.ToString(), paras.ToArray()) > 0);
}
else
{
return(DbHelperSQL.ExecuteSql(conn, tran, strSql.ToString(), paras.ToArray()) > 0);
}
}
private string DoAdd(out int cid)
{
cid = 0;
Model.Customer model = new Model.Customer();
BLL.Customer bll = new BLL.Customer();
manager = GetAdminInfo();
model.c_name = txtName.Text.Trim();
model.c_type = (byte)Utils.ObjToInt(ddltype.SelectedValue);
model.c_num = txtNum.Text.ToString();
model.c_isUse = cbIsUse.Checked;
model.c_remarks = txtRemark.Text.Trim();
model.c_flag = 0;
model.c_owner = manager.user_name;
model.c_ownerName = manager.real_name;
model.c_addDate = DateTime.Now;
model.c_business = txtBusinessScope.Text.Trim();
Model.Contacts contact = new Model.Contacts();
contact.co_flag = true;
contact.co_name = txtMContact.Text.Trim();
contact.co_number = txtMPhone.Text.Trim();
return(bll.Add(model, contact, manager, out cid));
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(Model.Customer model, Model.Contacts contact, out int cid)
{
cid = 0;
string result = string.Empty;
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();//打开数据连接
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
result = insertData(model, contact, conn, trans, out cid);
if (string.IsNullOrEmpty(result))
{
trans.Commit(); //提交事务
}
}
catch
{
trans.Rollback(); //回滚事务
result = "添加失败";
}
}
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Contacts GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder();
Model.Contacts model = new Model.Contacts();
//利用反射获得属性的所有公共属性
PropertyInfo[] pros = model.GetType().GetProperties();
foreach (PropertyInfo p in pros)
{
str1.Append(p.Name + ",");//拼接字段
}
strSql.Append("select top 1 " + str1.ToString().Trim(','));
strSql.Append(" from MS_Contacts");
strSql.Append(" where co_id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
DataTable dt = DbHelperSQL.Query(strSql.ToString(), parameters).Tables[0];
if (dt.Rows.Count > 0)
{
return(DataRowToModel(dt.Rows[0]));
}
else
{
return(null);
}
}
private string DoAdd()
{
Model.Contacts model = new Model.Contacts();
BLL.Contacts bll = new BLL.Contacts();
manager = GetAdminInfo();
model.co_cid = cid;
model.co_flag = false;
model.co_name = txtName.Text.Trim();
model.co_number = txtPhone.Text.Trim();
return(bll.Add(model, manager));
}
private void ShowInfo(int _id)
{
BLL.Contacts bll = new BLL.Contacts();
Model.Contacts model = bll.GetModel(_id);
txtName.Text = model.co_name;
txtPhone.Text = model.co_number;
if (model.co_flag.Value)
{
labflag.Text = "主要联系人";
}
}
public IList <Model.Contacts> GetContacts()
{
var contacts = new List <Model.Contacts>();
var context = Android.App.Application.Context;
var cur = context.ContentResolver.Query(ContactsContract.Contacts.ContentUri,
null, null, null, null);
cur?.L(c =>
{
var columns = cur.GetColumnNames();
while (cur.MoveToNext())
{
var rawName = cur.GetString(cur.GetColumnIndex(ContactsContract.ContactsColumns.NameRawContactId));
var name = cur.GetString(cur.GetColumnIndex(ContactsContract.ContactsColumns.DisplayName));
var hasPhone = cur.GetString(cur.GetColumnIndex(ContactsContract.ContactsColumns.HasPhoneNumber));
var photo = cur.GetString(cur.GetColumnIndex(ContactsContract.ContactsColumns.PhotoThumbnailUri));
var pResp = context.ContentResolver.Query(
ContactsContract.CommonDataKinds.Phone.ContentUri, null,
"contact_id" + " = ?",
new String[] { rawName }, null);
var _columns = pResp.GetColumnNames();
List <string> phones = new List <string>();
while (pResp?.MoveToNext() ?? false)
{
String phoneNo = pResp.GetString(
pResp.GetColumnIndex(ContactsContract.CommonDataKinds.Phone.Number));
phones.Add(phoneNo);
}
var contact = new Model.Contacts
{
Name = name,
Phone = phones.FirstOrDefault()?.Replace(" ", "").Replace("-", "") ?? string.Empty,
OptionalPhones = string.Join(';', phones),
Photo = photo
};
contacts.Add(contact);
}
});
return(contacts);
}
/// <summary>
/// 更新一条数据
/// </summary>
public string Update(Model.Contacts model, Model.manager manager, string content)
{
if (string.IsNullOrEmpty(model.co_name))
{
return("请填写联系人");
}
if (string.IsNullOrEmpty(model.co_number))
{
return("请填写联系号码");
}
Model.Customer cu = new BLL.Customer().GetModel(model.co_cid.Value);
if (cu == null)
{
return("客户不存在");
}
if (cu.c_flag == 2)
{
return("客户已经审批通过，不能编辑联系人");
}
if (cu.c_type == 3)
{
return("内部客户不能编辑");
}
if (cu.c_owner != manager.user_name && cu.c_ownerName != manager.real_name)
{
if (!new BLL.permission().checkHasPermission(manager, "0301"))
{
return("不是客户所属人或无权限修改客户信息");
}
}
if (cu.c_type != 2)
{
string existMsg = Exists(model.co_number, model.co_id.Value);
if (!string.IsNullOrEmpty(existMsg))
{
return(existMsg);
}
}
if (dal.Update(model))
{
Model.business_log log = new Model.business_log();
log.ol_cid = model.co_cid.Value;
log.ol_title = "修改客户联系人";
log.ol_content = content;
log.ol_operateDate = DateTime.Now;
new business_log().Add(DTEnums.ActionEnum.Edit.ToString(), log, manager.user_name, manager.real_name);
return("");
}
return("修改失败");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Contacts model, SqlConnection conn = null, SqlTransaction tran = null)
{
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder(); //数据字段
StringBuilder str2 = new StringBuilder(); //数据参数
//利用反射获得属性的所有公共属性
PropertyInfo[] pros = model.GetType().GetProperties();
List <SqlParameter> paras = new List <SqlParameter>();
strSql.Append("insert into MS_Contacts(");
foreach (PropertyInfo pi in pros)
{
//如果不是主键则追加sql字符串
if (!pi.Name.Equals("co_id"))
{
//判断属性值是否为空
if (pi.GetValue(model, null) != null)
{
str1.Append(pi.Name + ","); //拼接字段
str2.Append("@" + pi.Name + ","); //声明参数
paras.Add(new SqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值
}
}
}
strSql.Append(str1.ToString().Trim(','));
strSql.Append(") values (");
strSql.Append(str2.ToString().Trim(','));
strSql.Append(") ");
strSql.Append(";select @@IDENTITY;");
object obj;
if (tran == null)
{
obj = DbHelperSQL.GetSingle(strSql.ToString(), paras.ToArray());
}
else
{
obj = DbHelperSQL.GetSingle(conn, tran, strSql.ToString(), paras.ToArray());
}
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(Model.Customer model, Model.Contacts contact, Model.manager manager, out int cid)
{
cid = 0;
if (string.IsNullOrEmpty(model.c_name))
{
return("请填写客户名称");
}
if (model.c_type == 0)
{
return("请选择客户类别");
}
if (new BLL.Customer().Exists(model.c_name))
{
return("该客户名称已存在");
}
if (string.IsNullOrEmpty(model.c_business))
{
return("请填写业务范围");
}
if (string.IsNullOrEmpty(contact.co_name))
{
return("主要联系人不能为空");
}
if (string.IsNullOrEmpty(contact.co_number))
{
return("主要联系号码不能为空");
}
if ((model.c_type == 2 || model.c_type == 3) && !new BLL.permission().checkHasPermission(manager, "0301"))
{
return("没有客户管理权限0301");
}
string result = string.Empty;
result = dal.Add(model, contact, out cid);
if (string.IsNullOrEmpty(result))
{
Model.business_log log = new Model.business_log();
log.ol_title = "添加客户";
log.ol_cid = cid;
log.ol_content = "客户名称：" + model.c_name + "<br/>客户类别：" + Common.BusinessDict.customerType()[model.c_type] + "<br/>信用代码(税号)：" + model.c_num + "<br/>业务范围：" + model.c_business + "<br/>备注：" + model.c_remarks + "<br/>主要联系人：" + contact.co_name + "<br/>主要联系人号码：" + contact.co_number + "";
log.ol_operateDate = DateTime.Now;
log.ol_operaterNum = manager.user_name;
log.ol_operaterName = manager.real_name;
new business_log().Add(DTEnums.ActionEnum.Add.ToString(), log, manager.user_name, manager.real_name);
return("");
}
return(result);
}
/// <summary>
/// Import Co-borrower to Contact
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private int ImportCoBorrower(DataRow dr)
{
if (dtExcelData.Columns.Contains("Co-Borrower First Name") && dtExcelData.Columns.Contains("Co-Borrower Last Name"))
{
if ((dr["Co-Borrower First Name"] == DBNull.Value || dr["Co-Borrower First Name"].ToString() == "") && (dr["Co-Borrower Last Name"] == DBNull.Value || dr["Co-Borrower Last Name"].ToString() == ""))
{
return(0);
}
}
else
{
return(0);
}
Contacts bContacts = new Contacts();
Model.Contacts mContacts = new Model.Contacts();
mContacts.FirstName = dr["Co-Borrower First Name"] == DBNull.Value ? "" : dr["Co-Borrower First Name"].ToString();
if (dtExcelData.Columns.Contains("Co-Borrower Middle Name"))
{
mContacts.MiddleName = dr["Co-Borrower Middle Name"] == DBNull.Value ? "" : dr["Co-Borrower Middle Name"].ToString();
}
mContacts.LastName = dr["Co-Borrower Last Name"] == DBNull.Value ? "" : dr["Co-Borrower Last Name"].ToString();
if (dtExcelData.Columns.Contains("Co-Borrower DOB"))
{
if (dr["Co-Borrower DOB"] != DBNull.Value && dr["Co-Borrower DOB"].ToString() != "")
{
mContacts.DOB = Convert.ToDateTime(dr["Co-Borrower DOB"]);
}
}
if (dtExcelData.Columns.Contains("Co-Borrower SSN"))
{
mContacts.SSN = dr["Co-Borrower SSN"] == DBNull.Value ? "" : dr["Co-Borrower SSN"].ToString();
}
if (dtExcelData.Columns.Contains("Co-Borrower Email"))
{
mContacts.Email = dr["Co-Borrower Email"] == DBNull.Value ? "" : dr["Co-Borrower Email"].ToString();
}
mContacts.ContactEnable = true;
mContacts.NickName = dr["Co-Borrower First Name"] == DBNull.Value ? "" : dr["Co-Borrower First Name"].ToString();
int iContactID = bContacts.Add(mContacts);
return(iContactID);
}
/// <summary>
/// 删除一条数据
/// </summary>
public string Delete(int id, Model.manager manager)
{
if (checkIsUse(id))
{
return("该联系人已被订单使用，不能删除");
}
Model.Contacts model = GetModel(id);
if (model == null)
{
return("联系人不存在");
}
Model.Customer cu = new BLL.Customer().GetModel(model.co_cid.Value);
if (cu == null)
{
return("客户不存在");
}
if (cu.c_flag == 2)
{
return("客户已经审批通过，不能删除联系人");
}
if (model.co_flag.Value)
{
return("不能删除主要联系人");
}
if (cu.c_owner != manager.user_name && cu.c_ownerName != manager.real_name)
{
if (!new BLL.permission().checkHasPermission(manager, "0301"))
{
return("不是客户所属人或无权限修改客户信息，不能删除联系人");
}
}
if (dal.Delete(id))
{
Model.business_log log = new Model.business_log();
log.ol_cid = model.co_cid.Value;
log.ol_title = "删除客户联系人";
log.ol_content = "次要联系人<br/>联系人：" + model.co_name + "<br/>联系号码：" + model.co_number;
log.ol_operateDate = DateTime.Now;
new business_log().Add(DTEnums.ActionEnum.Edit.ToString(), log, manager.user_name, manager.real_name);
return("");
}
return("删除失败");
}
/// <summary>
/// 将对象转换实体
/// </summary>
public Model.Contacts DataRowToModel(DataRow row)
{
Model.Contacts model = new Model.Contacts();
if (row != null)
{
//利用反射获得属性的所有公共属性
Type modelType = model.GetType();
for (int i = 0; i < row.Table.Columns.Count; i++)
{
//查找实体是否存在列表相同的公共属性
PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
if (proInfo != null && row[i] != DBNull.Value)
{
proInfo.SetValue(model, row[i], null);//用索引值设置属性值
}
}
}
return(model);
}
protected void BtnSave_Click(object sender, EventArgs e)
{
Model.Contacts modelcon = new Model.Contacts();
modelcon.Accounts = Accounts.Value;
modelcon.cName = cName.Value;
modelcon.Sex = Convert.ToBoolean(Convert.ToInt32(Sex.SelectedValue));
if (Bearthday.Value == "")
{
modelcon.Bearthday = null;
}
else
{
modelcon.Bearthday = Convert.ToDateTime(Bearthday.Value);
}
modelcon.editUser = UserNow.UserID;
modelcon.addDatetime = DateTime.Now;
modelcon.Appellation = Convert.ToInt32(Appellation.SelectedValue);
modelcon.department = Convert.ToInt32(department.SelectedValue);
modelcon.Post = Convert.ToInt32(Post.SelectedValue);
modelcon.officPhone = officPhone.Value;
modelcon.Phone = Phone.Value;
modelcon.Address = Address.Value;
modelcon.zipcode = zipcode.Value;
modelcon.Mail = Mail.Value;
modelcon.familyPhone = familyPhone.Value;
modelcon.Likes = Likes.Value;
modelcon.Remark = Remark.Value;
if (Request.QueryString["type"] == "add")
{
if (bllcon.Add(modelcon) > 0)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('新增成功');parent.window.location.reload();</script>");
}
}
else if (Request.QueryString["type"] == "edit")
{
modelcon.ID = Convert.ToInt32(Request.QueryString["id"]);
if (bllcon.Update(modelcon))
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('更新成功');parent.window.location.reload();</script>");
}
}
}
/// <summary>
/// Import Contact
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private int ImportContact(DataRow dr)
{
Contacts bContacts = new Contacts();
Model.Contacts mContacts = new Model.Contacts();
mContacts.FirstName = dr["Borrower First Name"] == DBNull.Value ? "" : dr["Borrower First Name"].ToString();
if (dtExcelData.Columns.Contains("Borrower Middle Name"))
{
mContacts.MiddleName = dr["Borrower Middle Name"] == DBNull.Value ? "" : dr["Borrower Middle Name"].ToString();
}
mContacts.LastName = dr["Borrower Last Name"] == DBNull.Value ? "" : dr["Borrower Last Name"].ToString();
mContacts.MailingAddr = dr["Borrower Address"] == DBNull.Value ? "" : dr["Borrower Address"].ToString();
mContacts.MailingCity = dr["Borrower City"] == DBNull.Value ? "" : dr["Borrower City"].ToString();
mContacts.MailingState = dr["Borrower State"] == DBNull.Value ? "" : dr["Borrower State"].ToString();
mContacts.MailingZip = dr["Borrower Zip"] == DBNull.Value ? "" : dr["Borrower Zip"].ToString();
if (dtExcelData.Columns.Contains("Borrower DOB"))
{
if (dr["Borrower DOB"] != DBNull.Value && dr["Borrower DOB"].ToString() != "")
{
mContacts.DOB = Convert.ToDateTime(dr["Borrower DOB"]);
}
}
if (dtExcelData.Columns.Contains("Borrower SSN"))
{
mContacts.SSN = dr["Borrower SSN"] == DBNull.Value ? "" : dr["Borrower SSN"].ToString();
}
mContacts.HomePhone = dr["Borrower Home Phone"] == DBNull.Value ? "" : dr["Borrower Home Phone"].ToString();
if (dtExcelData.Columns.Contains("Borrower Work Phone"))
{
mContacts.BusinessPhone = dr["Borrower Work Phone"] == DBNull.Value ? "" : dr["Borrower Work Phone"].ToString();
}
if (dtExcelData.Columns.Contains("Borrower Email"))
{
mContacts.Email = dr["Borrower Email"] == DBNull.Value ? "" : dr["Borrower Email"].ToString();
}
mContacts.ContactEnable = true;
mContacts.NickName = dr["Borrower First Name"] == DBNull.Value ? "" : dr["Borrower First Name"].ToString();
int iContactID = bContacts.Add(mContacts);
return(iContactID);
}
private void BindInfo()
{
int id = Convert.ToInt32(Request.QueryString["id"]);
Model.Contacts modelcon = bllcon.GetModel(id);
cName.Value = modelcon.cName;
Sex.SelectedValue = Convert.ToInt32(modelcon.Sex).ToString();
Bearthday.Value = modelcon.Bearthday.ToString();
Appellation.SelectedValue = Convert.ToInt32(modelcon.Appellation).ToString();
department.SelectedValue = Convert.ToInt32(modelcon.department).ToString();
officPhone.Value = modelcon.officPhone;
Phone.Value = modelcon.Phone;
Address.Value = modelcon.Address;
zipcode.Value = modelcon.zipcode;
Mail.Value = modelcon.Mail;
Post.SelectedValue = modelcon.Post.ToString();
familyPhone.Value = modelcon.familyPhone;
Likes.Value = modelcon.Likes;
Remark.Value = modelcon.Remark;
}
private string DoEdit(int _id)
{
BLL.Contacts bll = new BLL.Contacts();
Model.Contacts model = bll.GetModel(_id);
manager = GetAdminInfo();
string _content = string.Empty;
model.co_cid = cid;
if (model.co_name != txtName.Text.Trim())
{
_content += "联系人:" + model.co_name + "→<font color='red'>" + txtName.Text.Trim() + "<font><br/>";
}
model.co_name = txtName.Text.Trim();
if (model.co_number != txtPhone.Text.Trim())
{
_content += "联系号码:" + model.co_number + "→<font color='red'>" + txtPhone.Text.Trim() + "<font><br/>";
}
model.co_number = txtPhone.Text.Trim();
return(bll.Update(model, manager, _content));
}
protected void Page_Load(object sender, EventArgs e)
{
if (ContactId.HasValue)
{
BLL.Contacts ContactsManager = new BLL.Contacts();
Model.Contacts contact = ContactsManager.GetModel(ContactId.Value);
if (null != contact && null != contact.Picture)
{
Response.BinaryWrite(contact.Picture);
}
else
{
ResponseDefaultPicture();
}
}
else
{
ResponseDefaultPicture();
}
Response.End();
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(Model.Contacts model, Model.manager manager)
{
if (string.IsNullOrEmpty(model.co_name))
{
return("请填写联系人");
}
if (string.IsNullOrEmpty(model.co_number))
{
return("请填写联系号码");
}
string existMsg = Exists(model.co_number);
if (!string.IsNullOrEmpty(existMsg))
{
return(existMsg);
}
Model.Customer cu = new BLL.Customer().GetModel(model.co_cid.Value);
if (cu == null)
{
return("客户不存在");
}
if (cu.c_owner != manager.user_name && cu.c_ownerName != manager.real_name)
{
return("您不是该客户的所属人，不能添加联系人");
}
model.co_flag = false;
if (dal.Add(model) > 0)
{
Model.business_log log = new Model.business_log();
log.ol_cid = model.co_cid.Value;
log.ol_title = "添加客户联系人";
log.ol_content = "次要联系人<br/>联系人：" + model.co_name + "<br/>联系号码：" + model.co_number;
log.ol_operateDate = DateTime.Now;
new business_log().Add(DTEnums.ActionEnum.Add.ToString(), log, manager.user_name, manager.real_name);
return("");
}
return("添加失败");
}
/// <summary>
/// load data
/// </summary>
/// <param name="contactId"></param>
/// <param name="noteId"></param>
private void BindPage(int contactId, int noteId)
{
var bllProspectNotes = new ProspectNotes();
var bllContact = new Contacts();
Model.Contacts modelContact = bllContact.GetModel(contactId);
if (modelContact != null)
{
lblProperty.Text = modelContact.MailingAddr + " " + modelContact.MailingCity + " " + modelContact.MailingState +
" " + modelContact.MailingZip;
}
var curUser = new LoginUser();
lblSender.Text = curUser.sFirstName + " " + curUser.sLastName;
lblBorrower.Text = modelContact.LastName + ", " + modelContact.FirstName + " " + modelContact.MiddleName;
if (noteId > 0)
{
tbxNote.Text = bllProspectNotes.GetModel(noteId).Note;
}
}
public string insertData(Model.Customer model, Model.Contacts contact, SqlConnection conn, SqlTransaction trans, out int cid)
{
cid = 0;
DataSet ds = null;
#region 组织客户表添加语句
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder(); //数据字段
StringBuilder str2 = new StringBuilder(); //数据参数
//利用反射获得属性的所有公共属性
PropertyInfo[] pros = model.GetType().GetProperties();
List <SqlParameter> paras = new List <SqlParameter>();
strSql.Append("insert into MS_Customer(");
foreach (PropertyInfo pi in pros)
{
//如果不是主键则追加sql字符串
if (!pi.Name.Equals("c_id"))
{
//判断属性值是否为空
if (pi.GetValue(model, null) != null)
{
str1.Append(pi.Name + ","); //拼接字段
str2.Append("@" + pi.Name + ","); //声明参数
paras.Add(new SqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值
}
}
}
strSql.Append(str1.ToString().Trim(','));
strSql.Append(") values (");
strSql.Append(str2.ToString().Trim(','));
strSql.Append(") ");
strSql.Append(";select @@IDENTITY;");
#endregion
#region 添加客户==========================
int obj = 0;
obj = Convert.ToInt32(DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), paras.ToArray()));//带事务
#endregion
#region 添加联系人======================
if (obj > 0)
{
//检查联系人号码是否与其他客户的联系人号码一样
if (model.c_type != 2)
{
string sql = "select * from MS_customer c left join MS_contacts co on c.c_id = co.co_cid where c.c_type<>2 and co.co_number='" + contact.co_number + "'";
ds = DbHelperSQL.Query(conn, trans, sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return("客户【" + ds.Tables[0].Rows[0]["c_name"] + "】，联系人【" + ds.Tables[0].Rows[0]["co_name"] + "】的联系号码也是【" + contact.co_number + "】，请查实：是否为同一客户！");
}
}
cid = obj;
contact.co_cid = obj;
int oobj = new DAL.Contacts().Add(contact, conn, trans);
if (oobj > 0)
{
return("");
}
}
#endregion
return("添加失败");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.btnPreWarn.OnClientClick = string.Format("return previewEmailTemplate('{0}');", this.ddlWarningEmail.ClientID);
this.btnPreOverdue.OnClientClick = string.Format("return previewEmailTemplate('{0}');", this.ddlOverdueEmail.ClientID);
this.btnPreComple.OnClientClick = string.Format("return previewEmailTemplate('{0}');", this.ddlComleEmail.ClientID);
// bind email template
BLL.Template_Email emailTpltManager = new BLL.Template_Email();
DataTable dtEmailTplts = emailTpltManager.GetEmailTemplate("");
this.ddlWarningEmail.DataValueField = "TemplEmailId";
this.ddlWarningEmail.DataTextField = "Name";
this.ddlWarningEmail.DataSource = dtEmailTplts;
this.ddlWarningEmail.DataBind();
this.ddlWarningEmail.Items.Insert(0, new ListItem("--select an email template--", "0"));
this.ddlOverdueEmail.DataValueField = "TemplEmailId";
this.ddlOverdueEmail.DataTextField = "Name";
this.ddlOverdueEmail.DataSource = dtEmailTplts;
this.ddlOverdueEmail.DataBind();
this.ddlOverdueEmail.Items.Insert(0, new ListItem("--select an email template--", "0"));
this.ddlComleEmail.DataValueField = "TemplEmailId";
this.ddlComleEmail.DataTextField = "Name";
this.ddlComleEmail.DataSource = dtEmailTplts;
this.ddlComleEmail.DataBind();
this.ddlComleEmail.Items.Insert(0, new ListItem("--select an email template--", "0"));
BindTaskOwner();
if ("0" == Mode)
{
BLL.Prospect prospectManager = new BLL.Prospect();
Model.Prospect currProspect = prospectManager.GetModel(ContactId.GetValueOrDefault(0));
if (null == currProspect)
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(), "_Invalid3", "alert('Invalid query string.');window.close();", true);
return;
}
// set prospect's officer as task owner
ListItem listItem = this.ddlOwner.Items.FindByValue(currProspect.Loanofficer.GetValueOrDefault(0).ToString());
if (null != listItem)
listItem.Selected = true;
this.btnDelete.Enabled = false;
this.btnClone.Enabled = false;
int nContactId = -1;
if (!int.TryParse(Request.QueryString["ContactId"], out nContactId))
nContactId = -1;
Model.Contacts contact = contactsManager.GetModel(nContactId);
if (null != contact)
this.lblClient.Text = string.Format("{0}, {1} {2}", contact.LastName, contact.FirstName, contact.MiddleName);
else
{
PageCommon.AlertMsg(this, "Invalid contact id!");
ClientFun("closewindow", "closeBox(false, false);");
}
}
else if ("1" == Mode)
{
if (!ProspectTaskId.HasValue)
{
// if no ProspectTaskId，thorw exception
LPLog.LogMessage(LogType.Logerror, "Invalid client task id");
throw new Exception("Invalid client task id");
}
else
{
Model.ProspectTasks pt = ptManager.GetModel(ProspectTaskId.Value);
if (null == pt)
{
LPLog.LogMessage(LogType.Logerror, string.Format("Cannot find the task with ID:{0}", ProspectTaskId.Value));
}
else
{
if (pt.Completed.HasValue)
{
this.btnSave.Enabled = false;
this.btnDelete.Enabled = false;
}
Model.Contacts contact = contactsManager.GetModel(pt.ContactId);
if (null != contact)
this.lblClient.Text = string.Format("{0}, {1} {2}", contact.LastName, contact.FirstName, contact.MiddleName);
this.tbTaskName.Text = pt.TaskName;
this.ckbEnabled.Checked = pt.Enabled;
this.tbDesc.Text = pt.Desc;
ListItem listTaskItem = this.ddlOwner.Items.FindByValue(pt.OwnerId.GetValueOrDefault(0).ToString());
if (null != listTaskItem)
listTaskItem.Selected = true;
this.ddlOwner.SelectedIndex = pt.OwnerId.GetValueOrDefault();
if (pt.Due.HasValue)
this.tbDue.Text = pt.Due.Value.ToString("MM/dd/yyyy");
ListItem listItem = this.ddlWarningEmail.Items.FindByValue(pt.WarningEmailTemplId.GetValueOrDefault().ToString());
if (null != listItem)
listItem.Selected = true;
listItem = this.ddlOverdueEmail.Items.FindByValue(pt.OverdueEmailTemplId.GetValueOrDefault().ToString());
if (null != listItem)
listItem.Selected = true;
listItem = this.ddlComleEmail.Items.FindByValue(pt.CompletionEmailTemplid.GetValueOrDefault().ToString());
if (null != listItem)
listItem.Selected = true;
}
}
}
}
}
