//数据持久化
internal static void SaveToDb(MainProjectCreateInfo pMainProjectCreateInfo, MainProjectCreate pMainProjectCreate, bool pIsNew)
{
pMainProjectCreate.MainProjectCreateId = pMainProjectCreateInfo.mainProjectCreateId;
pMainProjectCreate.ClientId = pMainProjectCreateInfo.clientId;
pMainProjectCreate.ProjectLevelId = pMainProjectCreateInfo.projectLevelId;
pMainProjectCreate.ProjectTypeId = pMainProjectCreateInfo.projectTypeId;
pMainProjectCreate.YeWuId = pMainProjectCreateInfo.yeWuId;
pMainProjectCreate.SheetNum = pMainProjectCreateInfo.sheetNum;
pMainProjectCreate.ProjectName = pMainProjectCreateInfo.projectName;
pMainProjectCreate.PreMoney = pMainProjectCreateInfo.preMoney;
pMainProjectCreate.PreProfit = pMainProjectCreateInfo.preProfit;
pMainProjectCreate.IsNew = pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pMainProjectCreate.Save(UserName);
}
catch (Exception ex)
{
LogManager.getInstance().getLogger(typeof(MainProjectCreateInfo)).Error(ex);
if (ex.Message.Contains("插入重复键")) //违反了唯一键
{
throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pMainProjectCreateInfo.mainProjectCreateId = pMainProjectCreate.MainProjectCreateId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainProjectCreateInfo)))
{
ResetCache();
}
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List <MainProjectCreateInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(MainProjectCreateInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return(CachedEntityCommander.GetCache(cacheKey) as List <MainProjectCreateInfo>);
}
else
{
List <MainProjectCreateInfo> list = new List <MainProjectCreateInfo>();
MainProjectCreateCollection collection = new MainProjectCreateCollection();
Query qry = new Query(MainProjectCreate.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach (MainProjectCreate mainProjectCreate in collection)
{
MainProjectCreateInfo mainProjectCreateInfo = new MainProjectCreateInfo();
LoadFromDAL(mainProjectCreateInfo, mainProjectCreate);
list.Add(mainProjectCreateInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainProjectCreateInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return(list);
}
}
/// <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 <MainProjectCreateInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
if (pPageIndex <= 1)
{
pPageIndex = 1;
}
List <MainProjectCreateInfo> list = new List <MainProjectCreateInfo>();
Query q = MainProjectCreate.CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression, pOrderBy.ToString());
MainProjectCreateCollection collection = new MainProjectCreateCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (MainProjectCreate mainProjectCreate in collection)
{
MainProjectCreateInfo mainProjectCreateInfo = new MainProjectCreateInfo();
LoadFromDAL(mainProjectCreateInfo, mainProjectCreate);
list.Add(mainProjectCreateInfo);
}
pRecordCount = q.GetRecordCount();
return(list);
}
protected void PageInit()
{
int wkid = Convert.ToInt32(Request["SpecialExpId"].ToString());
SpecialExpInfo sp = new SpecialExpInfo(wkid);
lblApplyDate.Text = sp.ApplyDate.ToString();
lblApplyPeople.Text = sp.ApplyPeople.ToString();
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(sp.MainProjectCreateId));
lblMoneyNum.Text = project.PreMoney.ToString();
lblProject.Text = project.ProjectName.ToString();
txtReason.Text = sp.ApplyReason.ToString();
if (sp.ProjectStepId.ToString() != "")
{
ProjectStepInfo step = new ProjectStepInfo(Convert.ToInt32(sp.ProjectStepId));
lblStep.Text = step.ProjectStepName.ToString();
}
lblApplyMoney.Text = sp.ApplyMoney.ToString();
lblSheetNum.Text = sp.SheetNum.ToString();
if (sp.SignName == 1)
{
imgMarket.Visible = true;
}
else if (sp.SignName == 2)
{
imgMarket.Visible = true;
imgManager.Visible = true;
}
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List <MainProjectCreateInfo> pList, MainProjectCreateCollection pCollection)
{
foreach (MainProjectCreate mainProjectCreate in pCollection)
{
MainProjectCreateInfo mainProjectCreateInfo = new MainProjectCreateInfo();
LoadFromDAL(mainProjectCreateInfo, mainProjectCreate);
pList.Add(mainProjectCreateInfo);
}
}
//从后台获取数据
internal static void LoadFromDAL(MainProjectCreateInfo pMainProjectCreateInfo, MainProjectCreate pMainProjectCreate)
{
pMainProjectCreateInfo.mainProjectCreateId = pMainProjectCreate.MainProjectCreateId;
pMainProjectCreateInfo.clientId = pMainProjectCreate.ClientId;
pMainProjectCreateInfo.projectLevelId = pMainProjectCreate.ProjectLevelId;
pMainProjectCreateInfo.projectTypeId = pMainProjectCreate.ProjectTypeId;
pMainProjectCreateInfo.yeWuId = pMainProjectCreate.YeWuId;
pMainProjectCreateInfo.sheetNum = pMainProjectCreate.SheetNum;
pMainProjectCreateInfo.projectName = pMainProjectCreate.ProjectName;
pMainProjectCreateInfo.preMoney = pMainProjectCreate.PreMoney;
pMainProjectCreateInfo.preProfit = pMainProjectCreate.PreProfit;
pMainProjectCreateInfo.Loaded = true;
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(MainProjectCreateInfo pMainProjectCreateInfoFrom, MainProjectCreateInfo pMainProjectCreateInfoTo)
{
pMainProjectCreateInfoTo.MainProjectCreateId = pMainProjectCreateInfoFrom.mainProjectCreateId;
pMainProjectCreateInfoTo.ClientId = pMainProjectCreateInfoFrom.clientId;
pMainProjectCreateInfoTo.ProjectLevelId = pMainProjectCreateInfoFrom.projectLevelId;
pMainProjectCreateInfoTo.ProjectTypeId = pMainProjectCreateInfoFrom.projectTypeId;
pMainProjectCreateInfoTo.YeWuId = pMainProjectCreateInfoFrom.yeWuId;
pMainProjectCreateInfoTo.SheetNum = pMainProjectCreateInfoFrom.sheetNum;
pMainProjectCreateInfoTo.ProjectName = pMainProjectCreateInfoFrom.projectName;
pMainProjectCreateInfoTo.PreMoney = pMainProjectCreateInfoFrom.preMoney;
pMainProjectCreateInfoTo.PreProfit = pMainProjectCreateInfoFrom.preProfit;
pMainProjectCreateInfoTo.Loaded = pMainProjectCreateInfoFrom.Loaded;
}
public MainProjectCreateInfo GetMainProjectCreateInfoById(int MainProjectCreateId)
{
MainProjectCreateInfo mainProjectCreateInfo = null;//
try
{
mainProjectCreateInfo = new MainProjectCreateInfo(MainProjectCreateId);
}
catch (AppException)
{
return null;
}
return mainProjectCreateInfo;
}
public MainProjectCreateInfo GetMainProjectCreateInfoById(int MainProjectCreateId)
{
MainProjectCreateInfo mainProjectCreateInfo = null; //
try
{
mainProjectCreateInfo = new MainProjectCreateInfo(MainProjectCreateId);
}
catch (AppException)
{
return(null);
}
return(mainProjectCreateInfo);
}
protected void PageInit()
{
int opid = Convert.ToInt32(Request["OfferPriceId"].ToString());
OfferPriceInfo op = new OfferPriceInfo(opid);
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(op.MainProjectCreateId));
lblProject.Text = project.ProjectName;
lblProjectNum.Text = project.SheetNum;
EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(op.EmployeeId));
lblEmployee.Text = em.EmployeeName.ToString();
lblFillTableDate.Text = op.FillTableDate.ToString();
txtManagerView.Text = op.MangerView.ToString();
txtSectionView.Text = op.SectionView.ToString();
rblType.SelectedValue = op.OfferPriceTypeId.ToString();
txtProjectDes.Text = op.ProjectDes.ToString();
lblMoneySum.Text = op.ProductMoneySum.ToString();
if (op.OfferFileId.ToString() == "")
{
btnDownLoad.Enabled = false;
}
if (op.MoneySum != null)
{
lblMoneySum.Text = op.MoneySum.ToString();
}
lblSheetNum.Text = op.SheetNum.ToString();
if (op.MoneySum != null)
{
lblMoneySum.Text = op.MoneySum.ToString();
}
if (op.BigMoney != null)
{
lblBigMoney.Text = op.BigMoney.ToString();
}
if (op.IsSignName == 1)
{
imgMarket.Visible = true;
}
else if (op.IsSignName == 2)
{
imgMarket.Visible = true;
imgManager.Visible = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (rblOver.SelectedIndex == -1)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('请选择修正或通过！');</script>");
}
else
{
try
{
int cid = Convert.ToInt32(Request["ProjectCreateId"].ToString());
ProjectCreateInfo pc = new ProjectCreateInfo(cid);
pc.ManagerView = txtManagerView.Text.ToString();
if (rblOver.Items[0].Selected)
{
pc.State =5;
pc.Save();
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('您让申请人修正！');</script>");
}
else if (rblOver.Items[1].Selected)
{
pc.State = 4;
pc.Save();
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('审批通过！');</script>");
MainProjectCreateInfo p = new MainProjectCreateInfo();
p.ClientId = Convert.ToInt32(pc.ClientId);
p.PreMoney = pc.PreMoney.ToString();
p.PreProfit = pc.PreProfit.ToString();
p.ProjectLevelId = Convert.ToInt32(pc.ProjectLevelId);
p.ProjectName = pc.ProjectName.ToString();
p.ProjectTypeId = Convert.ToInt32(pc.ProjectTypeId);
p.SheetNum = pc.SheetNum.ToString();
p.YeWuId = Convert.ToInt32(pc.YeWuId);
p.Save();
}
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('保存失败：" + Ex.Message + "');", true);
}
}
}
protected void SpecialBind()
{
int wkid = Convert.ToInt32(Request["SpecialExpId"].ToString());
SpecialExpInfo sp = new SpecialExpInfo(wkid);
lblApplyDate.Text = sp.ApplyDate.ToString();
lblApplyPeople.Text = sp.ApplyPeople.ToString();
lblApplyMoney.Text = sp.ApplyMoney.ToString();
lblSheetNum.Text = sp.SheetNum.ToString();
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(sp.MainProjectCreateId));
lblMoneyNum.Text = project.PreMoney.ToString();
lblProject.Text = project.ProjectName.ToString();
lblReason.Text = sp.ApplyReason.ToString();
if (sp.ProjectStepId.ToString() != "")
{
ProjectStepInfo step = new ProjectStepInfo(Convert.ToInt32(sp.ProjectStepId));
lblStep.Text = step.ProjectStepName.ToString();
}
}
private void LoadFromId(int mainProjectCreateId)
{
if (CachedEntityCommander.IsTypeRegistered(typeof(MainProjectCreateInfo)))
{
MainProjectCreateInfo mainProjectCreateInfo = Find(GetList(), mainProjectCreateId);
if (mainProjectCreateInfo == null)
{
throw new AppException("未能在缓存中找到相应的键值对象");
}
Copy(mainProjectCreateInfo, this);
}
else
{
MainProjectCreate mainProjectCreate = new MainProjectCreate(mainProjectCreateId);
if (mainProjectCreate.IsNew)
{
throw new AppException("尚未初始化");
}
LoadFromDAL(this, mainProjectCreate);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (IsPageValid())
{
try
{
MainProjectCreateInfo project = new MainProjectCreateInfo();
project.PreMoney = txtPreMoney.Text.ToString();
project.PreProfit = txtPreProfit.Text.ToString();
project.ProjectLevelId = Convert.ToInt32(ddlProjectLevel.SelectedValue);
project.ProjectTypeId = Convert.ToInt32(ddlProjectType.SelectedValue);
project.ClientId = Convert.ToInt32(ddlClient.SelectedValue);
project.ProjectName = txtProjectName.Text.ToString();
project.SheetNum = txtSheetNum.Text.ToString();
project.Save();
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('��ӳɹ���');</script>");
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('���ʧ�ܣ�" + Ex.Message + "');", true);
}
}
}
protected void PageInit()
{
EmployeeInfo em = (EmployeeInfo)Session["Employee"];
lblApplyPeople.Text = em.EmployeeName;
int id = Convert.ToInt32(Request["SpecialExpId"].ToString());
SpecialExpInfo sp = new SpecialExpInfo(id);
txtApplyMoney.Text = sp.ApplyMoney.ToString();
txtApplyDate.Text = sp.ApplyDate.ToString();
txtReason.Text = sp.ApplyReason.ToString();
if (sp.MainProjectCreateId.ToString() !="")
{
ddlProject.SelectedValue = sp.MainProjectCreateId.ToString();
}
if (sp.ProjectStepId.ToString() != "")
{
ddlProjectStep.SelectedValue = sp.ProjectStepId.ToString();
}
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(sp.MainProjectCreateId));
lblMoneyNum.Text = project.PreMoney.ToString();
txtSheetNum.Text = sp.SheetNum.ToString();
string strRoleName = Session["RoleName"].ToString();
PositionInfo position = new PositionInfo(Convert.ToInt32(em.PositionId));
if (strRoleName == "Ա��" || position.PositionName == "�ۺ�����")
{
btnSign.Enabled = false;
btnSign.Visible = false;
}
}
protected void PageInit()
{
txtManagerView.ReadOnly = true;
int opid = Convert.ToInt32(Request["OfferPriceId"].ToString());
OfferPriceInfo op = new OfferPriceInfo(opid);
ddlProject.SelectedValue = op.MainProjectCreateId.ToString();
ddlEmployee.SelectedValue = op.EmployeeId.ToString();
txtFillTableDate.Text = op.FillTableDate.ToString();
txtManagerView.Text = op.MangerView.ToString();
txtSectionView.Text = op.SectionView.ToString();
txtSheetNum.Text = op.SheetNum.ToString();
txtProjectDes.Text = op.ProjectDes.ToString();
rblType.SelectedValue = op.OfferPriceTypeId.ToString();
lblMoneySum.Text = op.ProductMoneySum.ToString();
if (op.MoneySum != null)
{
txtMoneySum.Text = op.MoneySum.ToString();
}
if (op.BigMoney != null)
{
txtBigMoney.Text = op.BigMoney.ToString();
}
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(op.MainProjectCreateId));
lblProjectNum.Text = project.SheetNum.ToString();
if (op.OfferFileId != null)
{
OfferFileInfo of = new OfferFileInfo(Convert.ToInt32(op.OfferFileId));
lblUrl.Text = of.PhyFileName.ToString();
}
}
protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
int projectid = Convert.ToInt32(ddlProject.SelectedValue);
MainProjectCreateInfo project = new MainProjectCreateInfo(projectid);
lblProjectNum.Text = project.SheetNum.ToString();
}
public void DeleteById(MainProjectCreateInfo pMainProjectCreateInfo)
{
MainProjectCreateInfo mainProjectCreateInfo = new MainProjectCreateInfo(pMainProjectCreateInfo.MainProjectCreateId);
mainProjectCreateInfo.Delete();
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List< MainProjectCreateInfo> pList, MainProjectCreateCollection pCollection)
{
foreach (MainProjectCreate mainProjectCreate in pCollection)
{
MainProjectCreateInfo mainProjectCreateInfo = new MainProjectCreateInfo();
LoadFromDAL(mainProjectCreateInfo, mainProjectCreate );
pList.Add(mainProjectCreateInfo);
}
}
public object SaveMainProjectCreateInfo(MainProjectCreateInfo mainProjectCreateInfo)
{
mainProjectCreateInfo.Save();
return(mainProjectCreateInfo.MainProjectCreateId);
}
public List <MainProjectCreateInfo> GetMainProjectCreateInfoList()
{
return(MainProjectCreateInfo.GetList());
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List<MainProjectCreateInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(MainProjectCreateInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return CachedEntityCommander.GetCache(cacheKey) as List< MainProjectCreateInfo>;
}
else
{
List< MainProjectCreateInfo> list =new List< MainProjectCreateInfo>();
MainProjectCreateCollection collection=new MainProjectCreateCollection();
Query qry = new Query(MainProjectCreate.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach(MainProjectCreate mainProjectCreate in collection)
{
MainProjectCreateInfo mainProjectCreateInfo= new MainProjectCreateInfo();
LoadFromDAL(mainProjectCreateInfo,mainProjectCreate);
list.Add(mainProjectCreateInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainProjectCreateInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return list;
}
}
/// <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<MainProjectCreateInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
{
if(pPageIndex<=1)
pPageIndex=1;
List< MainProjectCreateInfo> list = new List< MainProjectCreateInfo>();
Query q = MainProjectCreate .CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression,pOrderBy.ToString());
MainProjectCreateCollection collection=new MainProjectCreateCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (MainProjectCreate mainProjectCreate in collection)
{
MainProjectCreateInfo mainProjectCreateInfo = new MainProjectCreateInfo();
LoadFromDAL(mainProjectCreateInfo, mainProjectCreate);
list.Add(mainProjectCreateInfo);
}
pRecordCount=q.GetRecordCount();
return list;
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(MainProjectCreateInfo pMainProjectCreateInfoTo)
{
Copy(this, pMainProjectCreateInfoTo);
}
protected void gvProject_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int projectid = Convert.ToInt32(gvProject.DataKeys[e.RowIndex].Value);
TextBox txtProjectName = gvProject.Rows[e.RowIndex].FindControl("txtProjectName") as TextBox;
TextBox txtPreMoney = gvProject.Rows[e.RowIndex].FindControl("txtPreMoney") as TextBox;
TextBox txtPreProfit = gvProject.Rows[e.RowIndex].FindControl("txtPreProfit") as TextBox;
DropDownList ddlProjectLevel = gvProject.Rows[e.RowIndex].FindControl("ddlProjectLevel") as DropDownList;
DropDownList ddlProjectType = gvProject.Rows[e.RowIndex].FindControl("ddlProjectType") as DropDownList;
DropDownList ddlClient = gvProject.Rows[e.RowIndex].FindControl("ddlClient") as DropDownList;
try
{
MainProjectCreateInfo project = new MainProjectCreateInfo(projectid);
project.ProjectName = txtProjectName.Text.ToString();
project.PreMoney = txtPreMoney.Text.ToString();
project.PreProfit = txtPreProfit.Text.ToString();
project.ProjectLevelId = Convert.ToInt32(ddlProjectLevel.SelectedValue);
project.ProjectTypeId = Convert.ToInt32(ddlProjectType.SelectedValue);
project.ClientId = Convert.ToInt32(ddlClient.SelectedValue);
project.Save();
gvProject.EditIndex = -1;
gvDataBind();
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('����ʧ�ܣ�" + Ex.Message + "');", true);
}
}
//数据持久化
internal static void SaveToDb(MainProjectCreateInfo pMainProjectCreateInfo, MainProjectCreate pMainProjectCreate,bool pIsNew)
{
pMainProjectCreate.MainProjectCreateId = pMainProjectCreateInfo.mainProjectCreateId;
pMainProjectCreate.ClientId = pMainProjectCreateInfo.clientId;
pMainProjectCreate.ProjectLevelId = pMainProjectCreateInfo.projectLevelId;
pMainProjectCreate.ProjectTypeId = pMainProjectCreateInfo.projectTypeId;
pMainProjectCreate.YeWuId = pMainProjectCreateInfo.yeWuId;
pMainProjectCreate.SheetNum = pMainProjectCreateInfo.sheetNum;
pMainProjectCreate.ProjectName = pMainProjectCreateInfo.projectName;
pMainProjectCreate.PreMoney = pMainProjectCreateInfo.preMoney;
pMainProjectCreate.PreProfit = pMainProjectCreateInfo.preProfit;
pMainProjectCreate.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pMainProjectCreate.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(MainProjectCreateInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pMainProjectCreateInfo.mainProjectCreateId = pMainProjectCreate.MainProjectCreateId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainProjectCreateInfo)))
{
ResetCache();
}
}
public void DeleteById(MainProjectCreateInfo pMainProjectCreateInfo)
{
MainProjectCreateInfo mainProjectCreateInfo = new MainProjectCreateInfo(pMainProjectCreateInfo.MainProjectCreateId);
mainProjectCreateInfo.Delete();
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(MainProjectCreateInfo pMainProjectCreateInfoFrom, MainProjectCreateInfo pMainProjectCreateInfoTo)
{
pMainProjectCreateInfoTo.MainProjectCreateId = pMainProjectCreateInfoFrom.mainProjectCreateId;
pMainProjectCreateInfoTo.ClientId = pMainProjectCreateInfoFrom.clientId;
pMainProjectCreateInfoTo.ProjectLevelId = pMainProjectCreateInfoFrom.projectLevelId;
pMainProjectCreateInfoTo.ProjectTypeId = pMainProjectCreateInfoFrom.projectTypeId;
pMainProjectCreateInfoTo.YeWuId = pMainProjectCreateInfoFrom.yeWuId;
pMainProjectCreateInfoTo.SheetNum = pMainProjectCreateInfoFrom.sheetNum;
pMainProjectCreateInfoTo.ProjectName = pMainProjectCreateInfoFrom.projectName;
pMainProjectCreateInfoTo.PreMoney = pMainProjectCreateInfoFrom.preMoney;
pMainProjectCreateInfoTo.PreProfit = pMainProjectCreateInfoFrom.preProfit;
pMainProjectCreateInfoTo.Loaded=pMainProjectCreateInfoFrom.Loaded;
}
protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlProject.SelectedItem.Text == "��ѡ����Ŀ����")
{
lblMoneyNum.Text = "";
}
else
{
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(ddlProject.SelectedValue));
lblMoneyNum.Text = project.PreMoney.ToString();
}
}
public object SaveMainProjectCreateInfo(MainProjectCreateInfo mainProjectCreateInfo)
{
mainProjectCreateInfo.Save();
return mainProjectCreateInfo . MainProjectCreateId;
}
public List <MainProjectCreateInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
{
return(MainProjectCreateInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount));
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(MainProjectCreateInfo pMainProjectCreateInfoTo)
{
Copy(this, pMainProjectCreateInfoTo);
}
protected void gvProject_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//����ƶ���ÿ��ʱ��ɫ����Ч��
e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e");
//�����������ָ����״Ϊ"С��"
e.Row.Attributes["style"] = "Cursor:hand";
if (!Convert.IsDBNull(gvProject.DataKeys[e.Row.RowIndex].Value))
{
int projectid = Convert.ToInt32(gvProject.DataKeys[e.Row.RowIndex].Value);
MainProjectCreateInfo project = new MainProjectCreateInfo(projectid);
DropDownList ddlProjectLevel = e.Row.FindControl("ddlProjectLevel") as DropDownList;
if (ddlProjectLevel != null)
{
DataTable dt = ProjectCreateInfo.getProjectLevel();
ddlProjectLevel.DataSource = dt;
ddlProjectLevel.DataTextField = "ProjectLevelName";
ddlProjectLevel.DataValueField = "ProjectLevelId";
ddlProjectLevel.DataBind();
ddlProjectLevel.SelectedValue = project.ProjectLevelId.ToString();
}
DropDownList ddlProjectType = e.Row.FindControl("ddlProjectType") as DropDownList;
if (ddlProjectType != null)
{
DataTable dt = ProjectCreateInfo.getProjectType();
ddlProjectType.DataSource = dt;
ddlProjectType.DataTextField = "ProjectTypeName";
ddlProjectType.DataValueField = "ProjectTypeId";
ddlProjectType.DataBind();
ddlProjectType.SelectedValue = project.ProjectTypeId.ToString();
}
DropDownList ddlClient = e.Row.FindControl("ddlClient") as DropDownList;
if (ddlClient != null)
{
DataTable dt = ClientInfo.getClientList();
ddlClient.DataSource = dt;
ddlClient.DataTextField = "ClientName";
ddlClient.DataValueField = "ClientValue";
ddlClient.DataBind();
ddlClient.SelectedValue = project.ClientId.ToString();
}
}
}
}
//从后台获取数据
internal static void LoadFromDAL(MainProjectCreateInfo pMainProjectCreateInfo, MainProjectCreate pMainProjectCreate)
{
pMainProjectCreateInfo.mainProjectCreateId = pMainProjectCreate.MainProjectCreateId;
pMainProjectCreateInfo.clientId = pMainProjectCreate.ClientId;
pMainProjectCreateInfo.projectLevelId = pMainProjectCreate.ProjectLevelId;
pMainProjectCreateInfo.projectTypeId = pMainProjectCreate.ProjectTypeId;
pMainProjectCreateInfo.yeWuId = pMainProjectCreate.YeWuId;
pMainProjectCreateInfo.sheetNum = pMainProjectCreate.SheetNum;
pMainProjectCreateInfo.projectName = pMainProjectCreate.ProjectName;
pMainProjectCreateInfo.preMoney = pMainProjectCreate.PreMoney;
pMainProjectCreateInfo.preProfit = pMainProjectCreate.PreProfit;
pMainProjectCreateInfo.Loaded=true;
}
