public MainOfferPriceInfo GetMainOfferPriceInfoById(int MainOfferPriceId)
{
MainOfferPriceInfo mainOfferPriceInfo = null;//
try
{
mainOfferPriceInfo = new MainOfferPriceInfo(MainOfferPriceId);
}
catch (AppException)
{
return null;
}
return mainOfferPriceInfo;
}
public object SaveMainOfferPriceInfo(MainOfferPriceInfo mainOfferPriceInfo)
{
mainOfferPriceInfo.Save();
return mainOfferPriceInfo . MainOfferPriceId;
}
public void DeleteById(MainOfferPriceInfo pMainOfferPriceInfo)
{
MainOfferPriceInfo mainOfferPriceInfo = new MainOfferPriceInfo(pMainOfferPriceInfo.MainOfferPriceId);
mainOfferPriceInfo.Delete();
}
//数据持久化
internal static void SaveToDb(MainOfferPriceInfo pMainOfferPriceInfo, MainOfferPrice pMainOfferPrice,bool pIsNew)
{
pMainOfferPrice.MainOfferPriceId = pMainOfferPriceInfo.mainOfferPriceId;
pMainOfferPrice.MainOfferPriceName = pMainOfferPriceInfo.mainOfferPriceName;
pMainOfferPrice.IsNew=pIsNew;
string UserName = SubsonicHelper.GetUserName();
try
{
pMainOfferPrice.Save(UserName);
}
catch(Exception ex)
{
LogManager.getInstance().getLogger(typeof(MainOfferPriceInfo)).Error(ex);
if(ex.Message.Contains("插入重复键"))//违反了唯一键
{
throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来，如果没有的话，默认为原始的出错提示
}
throw new AppException("保存失败");
}
pMainOfferPriceInfo.mainOfferPriceId = pMainOfferPrice.MainOfferPriceId;
//如果缓存存在，更新缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainOfferPriceInfo)))
{
ResetCache();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsPageValid())
{
try
{
EmployeeInfo em = (EmployeeInfo)Session["Employee"];
MainOfferPriceInfo mainop = new MainOfferPriceInfo();
mainop.Save();
int OpId = Convert.ToInt32(Request["OfferPriceId"].ToString());
OfferPriceInfo op = new OfferPriceInfo(OpId);
op.MainOfferPriceId = mainop.MainOfferPriceId;
if (ddlProject.SelectedValue != "")
{
op.MainProjectCreateId = Convert.ToInt32(ddlProject.SelectedValue);
}
if (ddlEmployee.SelectedValue != "")
{
op.EmployeeId = Convert.ToInt32(ddlEmployee.SelectedValue);
}
op.OfferPriceTypeId = Convert.ToInt32(rblType.SelectedValue);
DateTime date = DateTime.Now;
string strtoday = DateTime.Now.ToString("yyyyMMdd").Substring(2);
op.Today = strtoday;
op.SheetNum = txtSheetNum.Text.ToString();
op.FillTableDate = Convert.ToDateTime(txtFillTableDate.Text.ToString());
op.SectionView = txtSectionView.Text.ToString();
op.SheetNum = txtSheetNum.Text.ToString();
op.ProjectDes = txtProjectDes.Text.ToString();
op.MoneySum = txtMoneySum.Text.ToString();
op.BigMoney = txtBigMoney.Text.ToString();
op.ProductMoneySum = lblMoneySum.Text.ToString();
if (UpFile.HasFile == true)
{
string name = this.UpFile.FileName;
int startindex = this.UpFile.FileName.LastIndexOf(@"\") + 1;
string fileName = this.UpFile.FileName.Substring(startindex);
string phyFileName = this.Server.MapPath(@"~\Files\" + "OfferPrice") + @"\" + fileName;
this.UpFile.SaveAs(phyFileName);
OfferFileInfo of = new OfferFileInfo();
of.OfferFileName = fileName;//�ļ���
of.PhyFileName = UpFile.PostedFile.FileName;//�����ļ�·��
of.Save();
op.OfferFileId = Convert.ToInt32(of.OfferFileId);
}
op.SendEmployeeName = em.EmployeeName;
op.SendEmployeeId = em.EmployeeId;
op.PreIsApply = 1;
op.PreIsOver = 1;
op.IsApply = 0;
op.IsApprove = 0;
op.IsApply1 = 0;
op.IsApply2 = 0;
op.IsOver1 = 0;
op.IsOver2 = 0;
//GridViewǶ���ж�
op.IsMain = 1;
op.IsMain1 = 1;
op.IsMain2 = 1;
op.IsMain3 = 1;
op.IsNewCreate = 0;
op.IsSignName = 0;
op.Save();
if (UpFile.HasFile)
{
////�ļ��ϴ���ַ��Ŀ¼������ͨ��IIS���豾������ΪFTP������
//string FileSaveUri = @"ftp://192.168.11.70/www/Files/OfferPrice/";
////FTP�û������룬���DZ������û�������
//string ftpUser = "******";
//string ftpPassWord = "******";
//SendFiles(FileSaveUri, ftpUser, ftpPassWord);
this.UpFile.PostedFile.SaveAs(Server.MapPath("~/Files/OfferPrice/" + UpFile.FileName));
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('��ӳɹ���');</script>");
ViewState["Isbtn"] = "1";
txtSheetNum.Text = SheetNums.SheetNumOfOP("BJTB", strtoday);
gvProductInitBind();
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('���ʧ�ܣ�" + Ex.Message + "');", true);
}
}
}
//从后台获取数据
internal static void LoadFromDAL(MainOfferPriceInfo pMainOfferPriceInfo, MainOfferPrice pMainOfferPrice)
{
pMainOfferPriceInfo.mainOfferPriceId = pMainOfferPrice.MainOfferPriceId;
pMainOfferPriceInfo.mainOfferPriceName = pMainOfferPrice.MainOfferPriceName;
pMainOfferPriceInfo.Loaded=true;
}
/// <summary>
/// 批量装载
/// </summary>
internal static void LoadFromDALPatch(List< MainOfferPriceInfo> pList, MainOfferPriceCollection pCollection)
{
foreach (MainOfferPrice mainOfferPrice in pCollection)
{
MainOfferPriceInfo mainOfferPriceInfo = new MainOfferPriceInfo();
LoadFromDAL(mainOfferPriceInfo, mainOfferPrice );
pList.Add(mainOfferPriceInfo);
}
}
/// <summary>
/// 复制为另一个对象
/// </summary>
/// <param name="pIndustryTypeInfoTo"></param>
public void CopyTo(MainOfferPriceInfo pMainOfferPriceInfoTo)
{
Copy(this, pMainOfferPriceInfoTo);
}
/// <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<MainOfferPriceInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
{
if(pPageIndex<=1)
pPageIndex=1;
List< MainOfferPriceInfo> list = new List< MainOfferPriceInfo>();
Query q = MainOfferPrice .CreateQuery();
q.PageIndex = pPageIndex;
q.PageSize = pPageSize;
q.ORDER_BY(pSortExpression,pOrderBy.ToString());
MainOfferPriceCollection collection=new MainOfferPriceCollection();
collection.LoadAndCloseReader(q.ExecuteReader());
foreach (MainOfferPrice mainOfferPrice in collection)
{
MainOfferPriceInfo mainOfferPriceInfo = new MainOfferPriceInfo();
LoadFromDAL(mainOfferPriceInfo, mainOfferPrice);
list.Add(mainOfferPriceInfo);
}
pRecordCount=q.GetRecordCount();
return list;
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <returns></returns>
public static List<MainOfferPriceInfo> GetList()
{
string cacheKey = GetCacheKey();
//本实体已经注册成缓存实体，并且缓存存在的时候，直接从缓存取
if (CachedEntityCommander.IsTypeRegistered(typeof(MainOfferPriceInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
{
return CachedEntityCommander.GetCache(cacheKey) as List< MainOfferPriceInfo>;
}
else
{
List< MainOfferPriceInfo> list =new List< MainOfferPriceInfo>();
MainOfferPriceCollection collection=new MainOfferPriceCollection();
Query qry = new Query(MainOfferPrice.Schema);
collection.LoadAndCloseReader(qry.ExecuteReader());
foreach(MainOfferPrice mainOfferPrice in collection)
{
MainOfferPriceInfo mainOfferPriceInfo= new MainOfferPriceInfo();
LoadFromDAL(mainOfferPriceInfo,mainOfferPrice);
list.Add(mainOfferPriceInfo);
}
//生成缓存
if (CachedEntityCommander.IsTypeRegistered(typeof(MainOfferPriceInfo)))
{
CachedEntityCommander.SetCache(cacheKey, list);
}
return list;
}
}
/// <summary>
/// 复制一个对象，采用硬编码的方式，避免反射的低效
/// </summary>
/// <param name="pIndustryTypeInfoFrom"></param>
/// <param name="pIndustryTypeInfoTo"></param>
public static void Copy(MainOfferPriceInfo pMainOfferPriceInfoFrom, MainOfferPriceInfo pMainOfferPriceInfoTo)
{
pMainOfferPriceInfoTo.MainOfferPriceId = pMainOfferPriceInfoFrom.mainOfferPriceId;
pMainOfferPriceInfoTo.MainOfferPriceName = pMainOfferPriceInfoFrom.mainOfferPriceName;
pMainOfferPriceInfoTo.Loaded=pMainOfferPriceInfoFrom.Loaded;
}
public void DeleteById(MainOfferPriceInfo pMainOfferPriceInfo)
{
MainOfferPriceInfo mainOfferPriceInfo = new MainOfferPriceInfo(pMainOfferPriceInfo.MainOfferPriceId);
mainOfferPriceInfo.Delete();
}