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;
}
