/// <summary> /// 得到一个对象实体 /// </summary> public ECommerce.Admin.Model.AUserInfo DataRowToModel(DataRow row) { ECommerce.Admin.Model.AUserInfo model=new ECommerce.Admin.Model.AUserInfo(); if (row != null) { if(row["ID"]!=null && row["ID"].ToString()!="") { model.ID=Convert.ToInt32(row["ID"].ToString()); } if(row["Name"]!=null) { model.Name=row["Name"].ToString(); } if(row["UserName"]!=null) { model.UserName=row["UserName"].ToString(); } if(row["AUID"]!=null && row["AUID"].ToString()!="") { model.AUID=Convert.ToInt32(row["AUID"].ToString()); } if(row["EntID"]!=null && row["EntID"].ToString()!="") { model.EntID=Convert.ToInt32(row["EntID"].ToString()); } if(row["UID"]!=null && row["UID"].ToString()!="") { model.UID=Convert.ToInt32(row["UID"].ToString()); } if(row["CreateDate"]!=null && row["CreateDate"].ToString()!="") { model.CreateDate=Convert.ToDateTime(row["CreateDate"].ToString()); } } return model; }
/// <summary> /// 对象实体绑定数据 /// </summary> public ECommerce.Admin.Model.AUserInfo ReaderBind(IDataReader dataReader) { ECommerce.Admin.Model.AUserInfo model=new ECommerce.Admin.Model.AUserInfo(); object ojb; ojb = dataReader["ID"]; if(ojb != null && ojb != DBNull.Value) { model.ID=Convert.ToInt32(ojb); } model.Name=dataReader["Name"].ToString(); model.UserName=dataReader["UserName"].ToString(); ojb = dataReader["AUID"]; if(ojb != null && ojb != DBNull.Value) { model.AUID=Convert.ToInt32(ojb); } ojb = dataReader["EntID"]; if(ojb != null && ojb != DBNull.Value) { model.EntID=Convert.ToInt32(ojb); } ojb = dataReader["UID"]; if(ojb != null && ojb != DBNull.Value) { model.UID=Convert.ToInt32(ojb); } ojb = dataReader["CreateDate"]; if(ojb != null && ojb != DBNull.Value) { model.CreateDate=Convert.ToDateTime(ojb); } return model; }
protected void btnSub_Click(object sender, EventArgs e) { var name = txtName.Value.Trim(); var LoID = HiddenField1.Value; var Loaner = txtDId.Value; var EntID = HiddenField2.Value; if (string.IsNullOrEmpty(name)) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('请填写姓名!');</script>"); return; } if (string.IsNullOrEmpty(Loaner) || string.IsNullOrEmpty(LoID)) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('请选择小天使帐户名!');</script>"); return; } if (!string.IsNullOrEmpty(Request.QueryString["OrgId"])) { //try { // List<SqlParameter> parameters = new List<SqlParameter>(); // var parameter = new SqlParameter("@OrgId", DbType.AnsiString) { Value = Request.QueryString["OrgId"] }; // parameters.Add(parameter); // var dt = _dataDal.GetModel(Convert.ToInt32(Request.QueryString["OrgId"])); // if (null == dt) { // Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('设备信息不存在!');</script>"); // return; // } // var exists = _dataDal.GetModel(" PKey='" + PKey + "' and DID!=" + Convert.ToInt32(Request.QueryString["OrgId"]), // new List<SqlParameter>()); // if (null != exists) { // Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('设备编号已经存在!');</script>"); // return; // } // dt.PKey = PKey; // dt.DeviceName = name; // dt.Descri = descr; // dt.EnteringDate = Convert.ToDateTime(EnteringDate); // dt.Loanable = Convert.ToInt32(Loanable); // dt.PurchaseDep = PurchaseDep; // dt.Purchaser = Purchaser; // dt.UID = CurrentUser.UId; // var res = _dataDal.Update(dt); // if (res) { // Page.ClientScript.RegisterStartupScript(GetType(), "", // "<script>window.top.$op.location=window.top.$op.location;window.top.$modal.destroy();</script>"); // } // else { // Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('更新失败!');window.top.$modal.destroy();</script>"); // } //} //catch (Exception) { // Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('操作失败!');window.top.$modal.destroy();</script>"); //} } else { var model = new ECommerce.Admin.Model.AUserInfo { Name = name, CreateDate = DateTime.Now, UserName = Loaner, AUID = Convert.ToInt32(LoID), UID = CurrentUser.UId, EntID = Convert.ToInt32(EntID) }; var exists = _dataDal.GetModel(" UserName='******' ", new List<SqlParameter>()); if (null != exists) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('员工信息已经存在!');</script>"); return; } var resAdd = _dataDal.Add(model); if (resAdd > 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>window.top.$op.location=window.top.$op.location;window.top.$modal.destroy();</script>"); } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('新增失败!');window.top.$modal.destroy();</script>"); } } }