private void BindInfo() { //实体基类 See_AnimalInfo objSee_AnimalInfo = new See_AnimalInfo(); //以主键查询数据 objSee_AnimalInfo = SqlDataProvider.SqlDataProvider.GetInfoSee_AnimalInfoByUserID(this.UserId); if ((objSee_AnimalInfo != null)) { //加载绑定数 //txtNo.Text = objSee_AnimalInfo.No.ToString(); txtName.Text = objSee_AnimalInfo.Name.ToString(); ddlSex.SelectedValue = objSee_AnimalInfo.Sex.ToString(); txtKind.Text = objSee_AnimalInfo.Kind.ToString(); txtAge.Text = objSee_AnimalInfo.Age.ToString(); txtColor.Text = objSee_AnimalInfo.Color.ToString(); txtDescription.Text = objSee_AnimalInfo.Description.ToString(); ddlIsImmune.SelectedValue = Convert.ToBoolean(objSee_AnimalInfo.IsImmune) == true ? "是" : "否"; ddlIsJY.SelectedValue = objSee_AnimalInfo.Par1; imgShow.Src = _filedir + objSee_AnimalInfo.Picture.ToString(); } See_PersonInfo objSee_PersonInfo = SqlDataProvider.SqlDataProvider.GetInfoSee_PersonInfoByUserID(this.UserId); if ((objSee_PersonInfo != null)) { if (objSee_PersonInfo.Code != "") { chkHasCode.Checked = true; txtCode.Enabled = false; } txtCode.Text = objSee_PersonInfo.Code.ToString(); } }
protected void BindInfo() { //实体基类 See_PersonInfo objSee_PersonInfo = new See_PersonInfo(); //以主键查询数据 objSee_PersonInfo = SqlDataProvider.SqlDataProvider.GetInfoSee_PersonInfoByUserID(this.UserId); if ((objSee_PersonInfo != null)) { //加载绑定数 //txtName.Text = objSee_PersonInfo.Name.ToString(); txtAge.Text = objSee_PersonInfo.Age.ToString(); ddlSex.SelectedValue = objSee_PersonInfo.Sex.ToString(); txtProfession.Text = objSee_PersonInfo.Profession.ToString(); txtAddress.Text = objSee_PersonInfo.Address.ToString(); //if (objSee_PersonInfo.Code != "") //{ // chkHasCode.Checked = true; // txtCode.Enabled = false; //} //txtCode.Text = objSee_PersonInfo.Code.ToString(); //txtPar1.Text = objSee_PersonInfo.Par1.ToString(); //txtPar2.Text = objSee_PersonInfo.Par2.ToString(); //txtPar3.Text = objSee_PersonInfo.Par3.ToString(); //txtPar4.Text = objSee_PersonInfo.Par4.ToString(); //txtPar5.Text = objSee_PersonInfo.Par5.ToString(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (!Page.IsValid) { return; } //if (chkHasCode.Checked) //{ // //判断code // See_Code objcode = SqlDataProvider.SqlDataProvider.GetInfoSee_CodeByCode(txtCode.Text); // if (objcode != null) // { // if (objcode.UserID > 0 && objcode.UserID != this.UserId) // { // Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "resultTip", "<script>alert('芯片编码已使用!');</script>"); // return; // } // } // else // { // Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "resultTip", "<script>alert('芯片编码不存在!');</script>"); // return; // } //} See_PersonInfo objSee_PersonInfo = new See_PersonInfo(); EasySite.Common.Utilities.CBO.InitializeObject(objSee_PersonInfo, typeof(See_PersonInfo)); //绑定更新数据信息 objSee_PersonInfo.UserID = this.UserId; //objSee_PersonInfo.Name = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtName.Text); objSee_PersonInfo.Age = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtAge.Text); objSee_PersonInfo.Sex = ddlSex.SelectedValue; objSee_PersonInfo.Profession = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtProfession.Text); objSee_PersonInfo.Address = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtAddress.Text); //objSee_PersonInfo.Code = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtCode.Text); objSee_PersonInfo.CreateTime = DateTime.Now; //objSee_PersonInfo.Par1 = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtPar1.Text); //objSee_PersonInfo.Par2 = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtPar2.Text); //objSee_PersonInfo.Par3 = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtPar3.Text); //objSee_PersonInfo.Par4 = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtPar4.Text); //objSee_PersonInfo.Par5 = PeoNormalControl.CommonClass.Utility.ReplaceSepChars(txtPar5.Text); SqlDataProvider.SqlDataProvider.InsertOrUpdateSee_PersonInfo(objSee_PersonInfo); //if (chkHasCode.Checked && txtCode.Text != "") //{ // SqlDataProvider.SqlDataProvider.UpdateSee_CodeInfoByCode(UserId, txtCode.Text); //} Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "resultTip", "<script>alert('提交成功!');window.location.href=window.location.href;</script>"); } catch (Exception exc) { EasySite.Services.Exceptions.Exceptions.ProcessModuleLoadException(this, exc); } }
protected void BindData() { //根据用户UserID获取主人资料 See_PersonInfo info = SqlDataProvider.SqlDataProvider.GetInfoSee_PersonInfoByUserID(this.UserId); if (info != null) { lblAge.Text = info.Age; lblSex.Text = info.Sex; lblProfession.Text = info.Profession; lblAddress.Text = info.Address; } }
public static Int32 InsertOrUpdateSee_PersonInfo(See_PersonInfo objSee_PersonInfo) { return Convert.ToInt32(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(strDBConnectionString, "See_PersonInfo_InsertOrUpdate", GetNull(objSee_PersonInfo.UserID), objSee_PersonInfo.Name, objSee_PersonInfo.Age, objSee_PersonInfo.Sex, objSee_PersonInfo.Profession, objSee_PersonInfo.Address, objSee_PersonInfo.Code, GetNull(objSee_PersonInfo.CreateTime), objSee_PersonInfo.Par1, objSee_PersonInfo.Par2, objSee_PersonInfo.Par3, objSee_PersonInfo.Par4, objSee_PersonInfo.Par5)); }
/// <summary> /// 更新一条信息 /// </summary> /// <param name="objSee_PersonInfo">实例对象</param> public static void UpdateSee_PersonInfo(See_PersonInfo objSee_PersonInfo) { Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(strDBConnectionString, "See_PersonInfo_Update", GetNull(objSee_PersonInfo.ID), GetNull(objSee_PersonInfo.UserID), objSee_PersonInfo.Name, objSee_PersonInfo.Age, objSee_PersonInfo.Sex, objSee_PersonInfo.Profession, objSee_PersonInfo.Address, objSee_PersonInfo.Code, GetNull(objSee_PersonInfo.CreateTime), objSee_PersonInfo.Par1, objSee_PersonInfo.Par2, objSee_PersonInfo.Par3, objSee_PersonInfo.Par4, objSee_PersonInfo.Par5); }