/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(NCPEP.Model.T_TurnOutType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_TurnOutType set ");
strSql.Append("TurnOutTypeName=@TurnOutTypeName,");
strSql.Append("Editor=@Editor,");
strSql.Append("CreateDate=@CreateDate");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@TurnOutTypeName", SqlDbType.NVarChar, 50),
new SqlParameter("@Editor", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.TurnOutTypeName;
parameters[1].Value = model.Editor;
parameters[2].Value = model.CreateDate;
parameters[3].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(NCPEP.Model.T_TurnOutType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_TurnOutType(");
strSql.Append("TurnOutTypeName,Editor,CreateDate)");
strSql.Append(" values (");
strSql.Append("@TurnOutTypeName,@Editor,@CreateDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TurnOutTypeName", SqlDbType.NVarChar, 50),
new SqlParameter("@Editor", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = model.TurnOutTypeName;
parameters[1].Value = model.Editor;
parameters[2].Value = model.CreateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NCPEP.Model.T_TurnOutType DataRowToModel(DataRow row)
{
NCPEP.Model.T_TurnOutType model = new NCPEP.Model.T_TurnOutType();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["TurnOutTypeName"] != null)
{
model.TurnOutTypeName = row["TurnOutTypeName"].ToString();
}
if (row["Editor"] != null)
{
model.Editor = row["Editor"].ToString();
}
if (row["CreateDate"] != null && row["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(row["CreateDate"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NCPEP.Model.T_TurnOutType GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,TurnOutTypeName,Editor,CreateDate from T_TurnOutType ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
NCPEP.Model.T_TurnOutType model = new NCPEP.Model.T_TurnOutType();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void Jzs()
{
if (Request.QueryString["p"] != null)
{
NCPEP.Bll.T_Bid bllbid = new NCPEP.Bll.T_Bid();
NCPEP.Model.T_Bid modelbid = new NCPEP.Model.T_Bid();
try
{
modelbid = bllbid.GetModel(int.Parse(Request.QueryString["p"]));
}
catch { }
if (modelbid != null)
{
NCPEP.Bll.T_LiceTran blltr = new NCPEP.Bll.T_LiceTran();
NCPEP.Model.T_LiceTran modeltr = new NCPEP.Model.T_LiceTran();
try
{
modeltr = blltr.GetModel(modelbid.FK_LiceTranId);
}
catch { }
try
{
// lbnjz.Text = System.DateTime.Now.Year.ToString();
}
catch { }
try
{
lbjycp.Text = modelbid.BidName;
}
catch { }
//try
//{
// lbxmbh.Text = "HJNJ" + modelbid.Admissibility;
//}
//catch { }
try
{
//鉴证书号码
lbxmbh.Text = "HJNJ" + modelbid.NoAssurance;
}
catch { }
try
{
this.lbzcf.Text = modeltr.Owner;
}
catch { }
try
{
this.lbsyqr.Text = modeltr.Name;
}
catch { }
NCPEP.Bll.T_MemberTypeCertification bllmem = new NCPEP.Bll.T_MemberTypeCertification();
NCPEP.Model.T_MemberTypeCertification modelmem = new NCPEP.Model.T_MemberTypeCertification();
try
{
modelmem = bllmem.GetModel(modeltr.MemberTypeId);
}
catch { }
if (modelmem != null)
{
this.lbzcxwpzjg.Text = modelmem.TypeCertificationName;
}
// this.lbzcxwpzjg.Text = modeltr.MemberTypeId;
try
{
//转出方资本
this.lbzcfdb.Text = modeltr.Capital;
}
catch { }
try
{
this.lbzcfsfz.Text = modeltr.IDCard;
}
catch { }
try
{
this.lbcqlx.Text = modelbid.Properties;
}
catch { }
NCPEP.Bll.T_PropertyType bllpro = new NCPEP.Bll.T_PropertyType();
NCPEP.Model.T_PropertyType modelpro = new NCPEP.Model.T_PropertyType();
try
{
modelpro = bllpro.GetModel(int.Parse(lbcqlx.Text));
if (modelpro != null)
{
this.lbcqlx.Text = modelpro.PropertyTypeName;
}
}
catch { }
NCPEP.Bll.T_BidTrans blltrans = new NCPEP.Bll.T_BidTrans();
DataTable dt = blltrans.GetList("FK_BidId='" + modelbid.Id + "'").Tables[0];
if (dt.Rows.Count > 0)
{
modeltr = new NCPEP.Model.T_LiceTran();
try
{
modeltr = blltr.GetModel(int.Parse(dt.Rows[0]["FK_LiceTranId"].ToString()));
}
catch { }
if (modeltr != null)
{
try
{
lbsrf.Text = modeltr.Name;
}
catch { }
try
{
lbsrffddbr.Text = modeltr.Owner;
}
catch { }
try
{
modelmem = new NCPEP.Model.T_MemberTypeCertification();
}
catch { }
try
{
modelmem = bllmem.GetModel(modeltr.MemberTypeId);
}
catch { }
if (modelmem != null)
{
lbgsxz.Text = modelmem.TypeCertificationName;
}
try
{
lbzczb.Text = modeltr.Capital;
}
catch { }
try
{
lbsrfsfz.Text = modeltr.IDCard;
}
catch { }
}
}
try
{
lbbdjbqk.Text = modelbid.BidBasic;
//lbzcqx.Text = "自" + DateTime.Parse(modelbid.StartDate.ToString()).ToString("yyyy年MM月dd日") + "起 至" + DateTime.Parse(modelbid.EndDate.ToString()).ToString("yyyy年MM月dd日") + "止";
}
catch { }
try
{
//批准机构
lbqqjg.Text = modelbid.FeedingMechanism;
}
catch { }
try
{
lbguimo.Text = modelbid.guimo + modelbid.danwei;
}
catch { }
NCPEP.Bll.T_TurnOutType bllout = new NCPEP.Bll.T_TurnOutType();
NCPEP.Model.T_TurnOutType modelout = new NCPEP.Model.T_TurnOutType();
try
{
modelout = bllout.GetModel(int.Parse(modelbid.TurnOut.ToString()));
}
catch { }
if (modelout != null)
{
try
{
lbzcfs.Text = modelout.TurnOutTypeName;
}
catch { }
}
else
{
try
{
lbzcfs.Text = modelbid.TurnOut.ToString();//转出方式
}
catch { }
}
//交易单价
try
{
lbjydj.Text = modelbid.ListingPrice;
}
catch { }
DataTable dts = new DataTable();
try
{
dts = DbHelperSQL.Query("select * from T_StandardMode where id='" + modelbid.StandardMode + "'").Tables[0];
if (dts.Rows.Count > 0)
{
lbjyfs.Text = dts.Rows[0]["StandardModeName"].ToString();
}
}
catch { lbjyfs.Text = ""; }
DataTable dtjzs = new DataTable();
NCPEP.Bll.T_Jzs blljzs = new NCPEP.Bll.T_Jzs();
dtjzs = blljzs.GetList("binid='" + modelbid.Id + "'").Tables[0];
if (dtjzs.Rows.Count > 0)
{
lbcjje.Text = dtjzs.Rows[0]["cjje"].ToString();
lbhtbh.Text = dtjzs.Rows[0]["htbh"].ToString();
lbbeizhu.Text = dtjzs.Rows[0]["beizhu"].ToString();
try
{
//转出期限
lbzcqx.Text = "自" + DateTime.Parse(dtjzs.Rows[0]["zcdate"].ToString()).ToString("yyyy年MM月dd日") + "起至" + DateTime.Parse(dtjzs.Rows[0]["zcdatez"].ToString()).ToString("yyyy年MM月dd日") + "止";
}
catch { }
try
{
//支付方式
lbhtqsrq.Text = dtjzs.Rows[0]["beiyong"].ToString();
}
catch { }
//交易单价
try
{
lbjydj.Text = dtjzs.Rows[0]["beiyong2"].ToString();
}
catch { }
try
{
//转出开始时间+3天变成打印时间
DateTime dysj = DateTime.Parse(dtjzs.Rows[0]["zcdate"].ToString());
if (dysj.Day != System.DateTime.Now.Day && dysj.Month != System.DateTime.Now.Month && dysj.Month != System.DateTime.Now.Year)
{
lbnian.Text = dysj.AddDays(3).Year.ToString();
lbyue.Text = dysj.AddDays(3).Month.ToString();
lbri.Text = dysj.AddDays(3).Day.ToString();
}
else
{
lbnian.Text = System.DateTime.Now.Year.ToString();
lbyue.Text = System.DateTime.Now.Month.ToString();
lbri.Text = System.DateTime.Now.Day.ToString();
}
}
catch { }
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(NCPEP.Model.T_TurnOutType model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(NCPEP.Model.T_TurnOutType model)
{
return(dal.Add(model));
}
