/// <summary>
/// ��ȡ֤����Ϣ
/// </summary>
/// <param name="ceInfoid">֤����ϢId</param>
/// <returns>����ʵ�����</returns>
public XYECOM.Model.CertificateInfo GetItem(long ceInfoid)
{
XYECOM.Model.CertificateInfo info = null;
SqlParameter[] Parame = new SqlParameter[]
{
new SqlParameter("@strWhere "," where CE_ID=" +ceInfoid.ToString()),
new SqlParameter("@strTableName"," u_Certificate "),
new SqlParameter("@strOrder"," " ),
};
using (SqlDataReader rdr = XYECOM.Core.Data.SqlHelper.ExecuteReader( CommandType.StoredProcedure, "XYP_SelectByWhere", Parame))
{
if (rdr.Read())
{
info = new XYECOM.Model.CertificateInfo();
info.CE_ID = Core.MyConvert.GetInt64(rdr["CE_ID"].ToString());
info.U_ID = Core.MyConvert.GetInt64(rdr["U_ID"].ToString());
info.CE_Name = rdr["CE_Name"].ToString();
info.CE_Organ = rdr["CE_organ"].ToString();
info.CE_Begin = Core.MyConvert.GetDateTime(rdr["CE_Begin"].ToString());
info.CE_Upto = Core.MyConvert.GetDateTime(rdr["CE_Upto"].ToString());
info.CE_Addtime = Core.MyConvert.GetDateTime(rdr["CE_AddTime"].ToString());
info.CE_Type = Core.MyConvert.GetInt32(rdr["CE_Type"].ToString());
info.CE_Isopen = rdr["CE_Isopen"].ToString().ToLower().Equals("true") ? true : false;
info.AuditingState = rdr["AuditingState"].ToString().Equals("1") ? Model.AuditingState.Passed : XYECOM.Model.AuditingState.NoPass;
}
}
return info;
}
protected void btnOK_Click(object sender, EventArgs e)
{
long infoId = 0;
infoId = XYECOM.Core.MyConvert.GetInt64(this.hidInfoId.Value);
XYECOM.Model.CertificateInfo car = null;
if (infoId > 0)
{
car = cerBLL.GetItem(infoId);
}
else
{
car = new XYECOM.Model.CertificateInfo();
}
car.U_ID = userinfo.CompanyId;
car.CE_Name = txtname.Text;
car.CE_Organ = txtorgan.Text;
car.CE_Type = Core.MyConvert.GetInt32(txttype.SelectedValue);
try
{
car.CE_Upto = Convert.ToDateTime(Request.Form["ctl00$ctl00$content$ContentPlaceHolder2$txtupto"]);
}
catch
{
car.CE_Upto = DateTime.Now.ToLocalTime();
}
try
{
car.CE_Begin = Convert.ToDateTime(Request.Form["ctl00$ctl00$content$ContentPlaceHolder2$txtbegin"]);
}
catch
{
car.CE_Begin = DateTime.Now.ToLocalTime();
}
car.CE_Isopen = true;
car.AuditingState = Model.AuditingState.Null;
if (car.CE_ID > 0)
{
cerBLL.Update(car);
}
else
{
int i = cerBLL.Insert(car, out infoId);
this.UploadImage1.InfoID = infoId;
}
this.UploadImage1.Update();
Response.Redirect("/Server/CertificateList.aspx");
}
