public ContactInfo GetContactInfoById(int ContactId)
{
ContactInfo contactInfo = null;//
try
{
contactInfo = new ContactInfo(ContactId);
}
catch (AppException)
{
return null;
}
return contactInfo;
}
//数据持久化
internal static void SaveToDb(ContactInfo pContactInfo, Contact pContact,bool pIsNew)
{
pContact.ContactId = pContactInfo.contactId;
pContact.Mobile = pContactInfo.mobile;
pContact.Officephone = pContactInfo.officephone;
pContact.PhoneExt = pContactInfo.phoneExt;
pContact.Homephone = pContactInfo.homephone;
pContact.Email = pContactInfo.email;
pContact.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pContact.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(ContactInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pContactInfo.contactId = pContact.ContactId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(ContactInfo)))
{
ResetCache();
}
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List< ContactInfo> pList, ContactCollection pCollection)
{
foreach (Contact contact in pCollection)
{
ContactInfo contactInfo = new ContactInfo();
LoadFromDAL(contactInfo, contact );
pList.Add(contactInfo);
}
}
//从后台获取数据
internal static void LoadFromDAL(ContactInfo pContactInfo, Contact pContact)
{
pContactInfo.contactId = pContact.ContactId;
pContactInfo.mobile = pContact.Mobile;
pContactInfo.officephone = pContact.Officephone;
pContactInfo.phoneExt = pContact.PhoneExt;
pContactInfo.homephone = pContact.Homephone;
pContactInfo.email = pContact.Email;
pContactInfo.Loaded=true;
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(ContactInfo pContactInfoTo)
{
Copy(this, pContactInfoTo);
}
/// <summary>
/// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据
/// </summary>
/// <param name="pPageIndex">页数</param>
/// <param name="pPageSize">每页列表</param>
/// <param name="pOrderBy">排序</param>
/// <param name="pSortExpression">排序字段</param>
/// <param name="pRecordCount">列表行数</param>
/// <returns>数据分页</returns>
public static List<ContactInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
{
if(pPageIndex<=1)
pPageIndex=1;
List< ContactInfo> list = new List< ContactInfo>();
Query q = Contact .CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression,pOrderBy.ToString());
ContactCollection collection=new ContactCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (Contact contact in collection)
{
ContactInfo contactInfo = new ContactInfo();
LoadFromDAL(contactInfo, contact);
list.Add(contactInfo);
}
pRecordCount=q.GetRecordCount();
return list;
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List<ContactInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(ContactInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return CachedEntityCommander.GetCache(cacheKey) as List< ContactInfo>;
}
else
{
List< ContactInfo> list =new List< ContactInfo>();
ContactCollection collection=new ContactCollection();
Query qry = new Query(Contact.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach(Contact contact in collection)
{
ContactInfo contactInfo= new ContactInfo();
LoadFromDAL(contactInfo,contact);
list.Add(contactInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(ContactInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return list;
}
}
public void DeleteById(ContactInfo pContactInfo)
{
ContactInfo contactInfo = new ContactInfo(pContactInfo.ContactId);
contactInfo.Delete();
}
public object SaveContactInfo(ContactInfo contactInfo)
{
contactInfo.Save();
return contactInfo . ContactId;
}
public void DeleteById(ContactInfo pContactInfo)
{
ContactInfo contactInfo = new ContactInfo(pContactInfo.ContactId);
contactInfo.Delete();
}
public object SaveContactInfo(ContactInfo contactInfo)
{
contactInfo.Save();
return(contactInfo.ContactId);
}
public List <ContactInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
return(ContactInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount));
}
public List <ContactInfo> GetContactInfoList()
{
return(ContactInfo.GetList());
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (IsPageValid())
{
try
{
string strAddress = txtAddress.Text.Trim();
string strCertificate = txtCertificate.Text.Trim();
string strEmployeeName = txtEmployeeName.Text.Trim();
string strIdentyNum = txtIdentyNum.Text.Trim();
string strMajor = txtMajor.Text.Trim();
string strNativePlace = txtNativePlace.Text.Trim();
string strSchool = txtSchool.Text.Trim();
string strEmail = txtEmail.Text.Trim();
string strHomephone = txtHomephone.Text.Trim();
string strMobile = txtMobile.Text.Trim();
string strPhoneExt = txtPhoneExt.Text.Trim();
string strOfficephone = txtOfficephone.Text.Trim();
DateTime dtBirthday = DateTime.Parse(txtBirthday.Text.Trim());
DateTime dtJobTime = DateTime.Parse(txtJobTime.Text.Trim());
DateTime dtJoinTime = DateTime.Parse(txtJoinTime.Text.Trim());
ContactInfo contact = new ContactInfo();
contact.Email = strEmail;
contact.Homephone = strHomephone;
contact.Mobile = strMobile;
contact.PhoneExt = strPhoneExt;
contact.Officephone = strOfficephone;
contact.Save();
EmployeeInfo Em = new EmployeeInfo();
if (ddlDepart.SelectedValue != "")
{
Em.DepartId = Convert.ToInt32(ddlDepart.SelectedValue.ToString());
}
if (ddlEducation.SelectedValue != "")
{
Em.EducationId = Convert.ToInt32(ddlEducation.SelectedValue);
}
if (ddlLanguage.SelectedValue != "")
{
Em.LanguageId = Convert.ToInt32(ddlLanguage.SelectedValue.ToString());
}
if (ddlPosition.SelectedValue != "")
{
Em.PositionId = Convert.ToInt32(ddlPosition.SelectedValue.ToString());
}
if (rblSex.SelectedValue != "")
{
Em.Sex = Convert.ToInt32(rblSex.SelectedValue.ToString());
}
if (rbtnMarrage.SelectedValue != "")
{
int iMarrage = Convert.ToInt32(rbtnMarrage.SelectedValue.ToString());
}
if (rblState.SelectedValue != "")
{
int iState = Convert.ToInt32(rblState.SelectedValue.ToString());
Em.State = iState;
if (iState == 1)
{
Em.OffJobTime = Convert.ToDateTime(txtLeaveDate.Text.ToString());
}
}
if (ddlPolitics.SelectedValue != "")
{
Em.PoliticsId = Convert.ToInt32(ddlPolitics.SelectedValue.ToString());
}
Em.EmLevelId = Convert.ToInt32(ddlLevel.SelectedValue.ToString());
Em.EmDangId = Convert.ToInt32(ddlDang.SelectedValue.ToString());
Em.ContactId = contact.ContactId;
Em.Address = strAddress;
Em.Birthday = dtBirthday;
Em.Certificate = strCertificate;
Em.EmployeeName = strEmployeeName;
Em.IdentyNum = strIdentyNum;
Em.JobTime = dtJobTime;
Em.JoinTime = dtJoinTime;
Em.Major = strMajor;
Em.NativePlace = strNativePlace;
Em.School = strSchool;
Em.Image = "~/Photo/" + ViewState["ImgUrl"];
Em.Qq = txtQq.Text.ToString();
Em.TurnTime = txtTurntime.Text.ToString();
Em.Save();
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('����û��ɹ���');</script>");
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('����û�ʧ�ܣ�" + Ex.Message + "');", true);
}
}
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(ContactInfo pContactInfoFrom, ContactInfo pContactInfoTo)
{
pContactInfoTo.ContactId = pContactInfoFrom.contactId;
pContactInfoTo.Mobile = pContactInfoFrom.mobile;
pContactInfoTo.Officephone = pContactInfoFrom.officephone;
pContactInfoTo.PhoneExt = pContactInfoFrom.phoneExt;
pContactInfoTo.Homephone = pContactInfoFrom.homephone;
pContactInfoTo.Email = pContactInfoFrom.email;
pContactInfoTo.Loaded=pContactInfoFrom.Loaded;
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(ContactInfo pContactInfoTo)
{
Copy(this, pContactInfoTo);
}
private void EmployeeBind()
{
int Employeeid = Convert.ToInt32(Request.QueryString["Employeeid"].ToString());
DataTable dt = EmployeeInfo.getEmployeeList(Employeeid);
txtEmployeeName.Text = dt.Rows[0]["EmployeeName"].ToString();
txtAddress.Text = dt.Rows[0]["Address"].ToString();
txtBirthday.Text = dt.Rows[0]["Birthday"].ToString();
txtCertificate.Text = dt.Rows[0]["Certificate"].ToString();
txtIdentyNum.Text = dt.Rows[0]["IdentyNum"].ToString();
txtJobTime.Text = dt.Rows[0]["JobTime"].ToString();
txtJoinTime.Text =dt.Rows[0]["JoinTime"].ToString();
txtMajor.Text = dt.Rows[0]["Major"].ToString();
txtNativePlace.Text = dt.Rows[0]["NativePlace"].ToString();
txtSchool.Text = dt.Rows[0]["School"].ToString();
txtQq.Text = dt.Rows[0]["Qq"].ToString();
ddlPolitics.SelectedValue = dt.Rows[0]["PoliticsId"].ToString();
ddlPosition.SelectedValue = dt.Rows[0]["PositionId"].ToString();
ddlDepart.SelectedValue = dt.Rows[0]["DepartId"].ToString();
ddlEducation.SelectedValue = dt.Rows[0]["EducationId"].ToString();
ddlLanguage.SelectedValue = dt.Rows[0]["LanguageId"].ToString();
ddlLevel.SelectedValue = dt.Rows[0]["EmLevelId"].ToString();
ddlDang.SelectedValue = dt.Rows[0]["EmDangId"].ToString();
rblSex.SelectedValue=dt.Rows[0]["Sex"].ToString();
rbtnMarrage.SelectedValue=dt.Rows[0]["Marrage"].ToString();
rblState.SelectedValue = dt.Rows[0]["State"].ToString();
int iState = Convert.ToInt32(dt.Rows[0]["State"].ToString());
if (iState == 1)
{
txtLeaveDate.Text = dt.Rows[0]["OffJobTime"].ToString();
txtLeaveDate.Enabled = true;
txtLeaveDate.Visible = true;
}
Image1.ImageUrl = dt.Rows[0]["Image"].ToString();
EmployeeInfo em=new EmployeeInfo(Employeeid);
ContactInfo contact = new ContactInfo(Convert.ToInt32(em.ContactId));
txtMobile.Text = contact.Mobile.ToString();
txtHomephone.Text = contact.Homephone.ToString();
txtOfficephone.Text = contact.Officephone.ToString();
txtEmail.Text = contact.Email.ToString();
txtPhoneExt.Text = contact.PhoneExt.ToString();
}