public bool UpdateByMiniPad(RecordsSelfcareabilityModel model, string RecordDate, string oldSelf) { StringBuilder builder = new StringBuilder(); builder.Append("UPDATE ARCHIVE_SELFCAREABILITY Self SET "); builder.Append("Dine=@Dine"); builder.Append(",Groming=@Groming"); builder.Append(",Dressing=@Dressing"); builder.Append(",Tolet=@Tolet"); builder.Append(",Activity=@Activity"); builder.Append(",TotalScore=@TotalScore "); builder.Append(",LastUpDateBy=@LastUpDateBy"); builder.Append(",LastUpDateDate=@LastUpDateDate"); builder.Append(@" WHERE EXISTS ( SELECT Self.ID FROM ARCHIVE_CUSTOMERBASEINFO BaseInfo INNER JOIN ARCHIVE_GENERALCONDITION G ON BaseInfo.ID = G.OutKey WHERE Self.ID= G.SelfID AND BaseInfo.IDCardNo = @IDCardNo AND BaseInfo.CheckDate = @CheckDate ); UPDATE ARCHIVE_GENERALCONDITION G SET OldSelfCareability =@OldSelfCareability WHERE EXISTS ( SELECT G.SelfID FROM ARCHIVE_CUSTOMERBASEINFO BaseInfo INNER JOIN ARCHIVE_SELFCAREABILITY med ON BaseInfo.IDCardNo = med.IDCardNo WHERE G.SelfID= med.ID AND BaseInfo.IDCardNo = @IDCardNo AND BaseInfo.CheckDate = @CheckDate );"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", model.IDCardNo), new MySqlParameter("@Dine", model.Dine), new MySqlParameter("@Groming", model.Groming), new MySqlParameter("@Dressing", model.Dressing), new MySqlParameter("@Tolet", model.Tolet), new MySqlParameter("@Activity", model.Activity), new MySqlParameter("@TotalScore", model.TotalScore), new MySqlParameter("@CheckDate", RecordDate), new MySqlParameter("@OldSelfCareability", oldSelf), new MySqlParameter("@LastUpDateBy", model.LastUpDateBy), new MySqlParameter("@LastUpDateDate", model.LastUpDateDate) }; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public int Add(RecordsSelfcareabilityModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ARCHIVE_SELFCAREABILITY("); builder.Append("CustomerID,RecordID,IDCardNo,Dine,Groming,Dressing,Tolet,Activity,TotalScore,FollowUpDate,"); builder.Append("FollowUpDoctor,NextfollowUpDate,CreatedBy,CreatedDate,LastUpDateBy,LastUpDateDate,NextVisitAim)"); builder.Append(" values ("); builder.Append("@CustomerID,@RecordID,@IDCardNo,@Dine,@Groming,@Dressing,@Tolet,@Activity,@TotalScore,"); builder.Append("@FollowUpDate,@FollowUpDoctor,@NextfollowUpDate,@CreatedBy,@CreatedDate,"); builder.Append("@LastUpDateBy,@LastUpDateDate,@NextVisitAim) "); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@CustomerID", MySqlDbType.String, 100), new MySqlParameter("@RecordID", MySqlDbType.String, 50), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@Dine", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Groming", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Dressing", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Tolet", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Activity", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@TotalScore", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@FollowUpDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 100), new MySqlParameter("@NextfollowUpDate", MySqlDbType.Date), new MySqlParameter("@CreatedBy", MySqlDbType.Decimal), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpDateBy", MySqlDbType.Decimal), new MySqlParameter("@LastUpDateDate", MySqlDbType.Date), new MySqlParameter("@NextVisitAim", MySqlDbType.String, 100) }; cmdParms[0].Value = model.CustomerID; cmdParms[1].Value = model.RecordID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.Dine; cmdParms[4].Value = model.Groming; cmdParms[5].Value = model.Dressing; cmdParms[6].Value = model.Tolet; cmdParms[7].Value = model.Activity; cmdParms[8].Value = model.TotalScore; cmdParms[9].Value = model.FollowUpDate; cmdParms[10].Value = model.FollowUpDoctor; cmdParms[11].Value = model.NextFollowUpDate; cmdParms[12].Value = model.CreatedBy; cmdParms[13].Value = model.CreatedDate; cmdParms[14].Value = model.LastUpDateBy; cmdParms[15].Value = model.LastUpDateDate; cmdParms[16].Value = model.NextVisitAim; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public int Add(RecordsSelfcareabilityModel model) { StringBuilder builder = new StringBuilder(); builder.Append("INSERT INTO ARCHIVE_SELFCAREABILITY("); builder.Append("CustomerID,RecordID,IDCardNo,Dine,Groming,Dressing,Tolet,Activity,TotalScore,FollowUpDate,"); builder.Append("FollowUpDoctor,NextfollowUpDate,CreatedBy,CreatedDate,LastUpDateBy,LastUpDateDate,NextVisitAim "); // 判断是否存在OutKey栏位,3.0用OutKey做关联 string table = "SELECT COUNT(0) FROM information_schema.columns WHERE TABLE_NAME = 'ARCHIVE_SELFCAREABILITY' AND TABLE_SCHEMA='kangshuo_db' AND COLUMN_NAME='OutKey'"; object single = MySQLHelper.GetSingle(table); int count = 0; if (single != null) { count = int.Parse(single.ToString()); } if (count > 0) { builder.Append(",OutKey "); } builder.Append(")"); builder.Append(" VALUES ("); builder.Append("@CustomerID,@RecordID,@IDCardNo,@Dine,@Groming,@Dressing,@Tolet,@Activity,@TotalScore,"); builder.Append("@FollowUpDate,@FollowUpDoctor,@NextfollowUpDate,@CreatedBy,@CreatedDate,"); builder.Append("@LastUpDateBy,@LastUpDateDate,@NextVisitAim "); // 判断是否存在OutKey栏位,3.0用OutKey做关联 if (count > 0) { builder.Append(",@OutKey "); } builder.Append(")"); builder.Append(";SELECT @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@CustomerID", MySqlDbType.String), new MySqlParameter("@RecordID", MySqlDbType.String), new MySqlParameter("@IDCardNo", MySqlDbType.String), new MySqlParameter("@Dine", MySqlDbType.Decimal), new MySqlParameter("@Groming", MySqlDbType.Decimal), new MySqlParameter("@Dressing", MySqlDbType.Decimal), new MySqlParameter("@Tolet", MySqlDbType.Decimal), new MySqlParameter("@Activity", MySqlDbType.Decimal), new MySqlParameter("@TotalScore", MySqlDbType.Decimal), new MySqlParameter("@FollowUpDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String), new MySqlParameter("@NextfollowUpDate", MySqlDbType.Date), new MySqlParameter("@CreatedBy", MySqlDbType.Decimal), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpDateBy", MySqlDbType.Decimal), new MySqlParameter("@LastUpDateDate", MySqlDbType.Date), new MySqlParameter("@NextVisitAim", MySqlDbType.String), new MySqlParameter("@OutKey", MySqlDbType.String) }; cmdParms[0].Value = model.CustomerID; cmdParms[1].Value = model.RecordID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.Dine; cmdParms[4].Value = model.Groming; cmdParms[5].Value = model.Dressing; cmdParms[6].Value = model.Tolet; cmdParms[7].Value = model.Activity; cmdParms[8].Value = model.TotalScore; cmdParms[9].Value = model.FollowUpDate; cmdParms[10].Value = model.FollowUpDoctor; cmdParms[11].Value = model.NextFollowUpDate; cmdParms[12].Value = model.CreatedBy; cmdParms[13].Value = model.CreatedDate; cmdParms[14].Value = model.LastUpDateBy; cmdParms[15].Value = model.LastUpDateDate; cmdParms[16].Value = model.NextVisitAim; cmdParms[17].Value = model.OutKey; single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public bool UpdateByMiniPad(RecordsSelfcareabilityModel model, string RecordDate, string oldSelf) { StringBuilder builder = new StringBuilder(); builder.Append("UPDATE ARCHIVE_SELFCAREABILITY Self SET "); builder.Append("Dine=@Dine"); builder.Append(",Groming=@Groming"); builder.Append(",Dressing=@Dressing"); builder.Append(",Tolet=@Tolet"); builder.Append(",Activity=@Activity"); builder.Append(",TotalScore=@TotalScore "); builder.Append(",LastUpDateBy=@LastUpDateBy"); builder.Append(",LastUpDateDate=@LastUpDateDate"); // 判断是否存在OutKey栏位,3.0用OutKey做关联 string table = "SELECT COUNT(0) FROM information_schema.columns WHERE TABLE_NAME = 'ARCHIVE_SELFCAREABILITY' AND TABLE_SCHEMA='kangshuo_db' AND COLUMN_NAME='OutKey'"; object single = MySQLHelper.GetSingle(table); int count = 0; if (single != null) { count = int.Parse(single.ToString()); } if (count > 0) { builder.Append(",OutKey=@OutKey "); } builder.Append(@" WHERE EXISTS ( SELECT Self.ID FROM ARCHIVE_CUSTOMERBASEINFO BaseInfo INNER JOIN ARCHIVE_GENERALCONDITION G ON BaseInfo.ID = G.OutKey WHERE Self.ID= G.SelfID AND BaseInfo.IDCardNo = @IDCardNo AND BaseInfo.CheckDate = @CheckDate ); UPDATE ARCHIVE_GENERALCONDITION G SET OldSelfCareability =@OldSelfCareability WHERE EXISTS ( SELECT G.SelfID FROM ARCHIVE_CUSTOMERBASEINFO BaseInfo INNER JOIN ARCHIVE_SELFCAREABILITY med ON BaseInfo.IDCardNo = med.IDCardNo WHERE G.SelfID= med.ID AND BaseInfo.IDCardNo = @IDCardNo AND BaseInfo.CheckDate = @CheckDate );"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", model.IDCardNo), new MySqlParameter("@Dine", model.Dine), new MySqlParameter("@Groming", model.Groming), new MySqlParameter("@Dressing", model.Dressing), new MySqlParameter("@Tolet", model.Tolet), new MySqlParameter("@Activity", model.Activity), new MySqlParameter("@TotalScore", model.TotalScore), new MySqlParameter("@CheckDate", RecordDate), new MySqlParameter("@OldSelfCareability", oldSelf), new MySqlParameter("@LastUpDateBy", model.LastUpDateBy), new MySqlParameter("@LastUpDateDate", model.LastUpDateDate), new MySqlParameter("@OutKey", model.OutKey) }; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool UpdateByMiniPad(RecordsSelfcareabilityModel model, string RecordDate, string oldSelf) { return(this.dal.UpdateByMiniPad(model, RecordDate, oldSelf)); }
public bool Update(RecordsSelfcareabilityModel model) { return(this.dal.Update(model)); }
public int Add(RecordsSelfcareabilityModel model) { return(this.dal.Add(model)); }
public bool Update(RecordsSelfcareabilityModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_SELFCAREABILITY set "); builder.Append("CustomerID=@CustomerID,"); builder.Append("RecordID=@RecordID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("Dine=@Dine,"); builder.Append("Groming=@Groming,"); builder.Append("Dressing=@Dressing,"); builder.Append("Tolet=@Tolet,"); builder.Append("Activity=@Activity,"); builder.Append("TotalScore=@TotalScore,"); builder.Append("FollowUpDate=@FollowUpDate,"); builder.Append("FollowUpDoctor=@FollowUpDoctor,"); builder.Append("NextfollowUpDate=@NextfollowUpDate,"); builder.Append("CreatedBy=@CreatedBy,"); builder.Append("CreatedDate=@CreatedDate,"); builder.Append("LastUpDateBy=@LastUpDateBy,"); builder.Append("LastUpDateDate=@LastUpDateDate,"); builder.Append("NextVisitAim=@NextVisitAim"); builder.Append(" where ID=@ID"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@CustomerID", MySqlDbType.String, 0x12), new MySqlParameter("@RecordID", MySqlDbType.String, 0x11), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@Dine", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Groming", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Dressing", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Tolet", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Activity", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@TotalScore", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@FollowUpDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 30), new MySqlParameter("@NextfollowUpDate", MySqlDbType.Date), new MySqlParameter("@CreatedBy", MySqlDbType.Decimal), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpDateBy", MySqlDbType.Decimal), new MySqlParameter("@LastUpDateDate", MySqlDbType.Date), new MySqlParameter("@NextVisitAim", MySqlDbType.String, 100), new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.CustomerID; cmdParms[1].Value = model.RecordID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.Dine; cmdParms[4].Value = model.Groming; cmdParms[5].Value = model.Dressing; cmdParms[6].Value = model.Tolet; cmdParms[7].Value = model.Activity; cmdParms[8].Value = model.TotalScore; cmdParms[9].Value = model.FollowUpDate; cmdParms[10].Value = model.FollowUpDoctor; cmdParms[11].Value = model.NextFollowUpDate; cmdParms[12].Value = model.CreatedBy; cmdParms[13].Value = model.CreatedDate; cmdParms[14].Value = model.LastUpDateBy; cmdParms[15].Value = model.LastUpDateDate; cmdParms[16].Value = model.NextVisitAim; cmdParms[17].Value = model.ID; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public void InitEveryThing() { //this.elderSelf = new RecordsSelfcareabilityBLL().GetModelID(this.SelfID); if (this.elderSelf == null) { RecordsSelfcareabilityModel olderSelfCareabilityModel = new RecordsSelfcareabilityModel { IDCardNo = this.Model.IDCardNo, RecordID = this.Model.RecordID, FollowUpDoctor = this.Model.Doctor, Dine = 0, Groming = 0, Dressing = 0, Tolet = 0, Activity = 0, CreatedDate = new DateTime?(DateTime.Today) }; this.elderSelf = olderSelfCareabilityModel; this.elderSelf.CreatedBy = new decimal?(ConfigHelper.GetNodeDec("doctor")); this.dtpNextF.Value = DateTime.Today.AddYears(1); } else { this.elderSelf.LastUpDateBy = new decimal?(ConfigHelper.GetNodeDec("doctor")); this.elderSelf.LastUpDateDate = new DateTime?(DateTime.Today); if (this.elderSelf.NextFollowUpDate.HasValue && PhysicalInfoFactoryID > 0) { this.dtpNextF.Value = this.elderSelf.NextFollowUpDate.Value; } else { this.dtpNextF.Value = DateTime.Today.AddYears(1); } } this.cp_elderSelf = GlbTools.DeepCopy(this.elderSelf); if (string.IsNullOrEmpty(this.elderSelf.FollowUpDoctor)) { this.elderSelf.FollowUpDoctor = ConfigHelper.GetNode("doctorName"); } this.tbDoctor.DataBindings.Add("TEXT", this.elderSelf, "FollowUpDoctor", false, DataSourceUpdateMode.OnPropertyChanged); if (string.IsNullOrEmpty(this.elderSelf.NextVisitAim)) { //this.elderSelf.NextVisitAim = "防意外,防伤害,防坠床。"; this.elderSelf.NextVisitAim = "低盐饮食,预防高血压"; } this.txbNextVisitAim.DataBindings.Add("TEXT", this.elderSelf, "NextVisitAim", false, DataSourceUpdateMode.OnPropertyChanged); this.CbSimpleBind(this.cbDinner, "DINE"); this.CbSimpleBind(this.cbGromming, "Groming"); this.CbSimpleBind(this.cbDressing, "Dressing"); this.CbSimpleBind(this.cbTolet, "Tolet"); this.CbSimpleBind(this.cbAct, "Activity"); if (this.elderSelf.TotalScore.HasValue) { this.tbTotal.Text = this.elderSelf.TotalScore.Value.ToString(); } else { this.tbTotal.Text = "0"; } if (this.elderSelf.FollowUpDate.HasValue) { this.dtpCheckdate.Value = this.elderSelf.FollowUpDate.Value; } else { this.dtpCheckdate.Value = DateTime.Today; } //if (this.elderSelf.NextFollowUpDate.HasValue) //{ // this.dtpNextF.Value = this.elderSelf.NextFollowUpDate.Value; //} //else //{ // this.dtpNextF.Value = DateTime.Today; //} MustChoose(); this.EveryThingIsOk = true; }