public ReturnValue AddUpdate(Surgery model)
{
ReturnValue resoult = dalSurgery.Search(model.EmployeeID,model.YearMonth);
if (!resoult.ErrorFlag)
{
return resoult;
}
if (resoult.Count > 0)
{
resoult = dalSurgery.Update(model);
if (resoult.ErrorFlag)
{
BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的外科信息", "1", model.TERMINAL_CD);
}
}
else
{
resoult = dalSurgery.Add(model);
if (resoult.ErrorFlag)
{
BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的外科信息", "1", model.TERMINAL_CD);
}
}
return resoult;
}
public ReturnValue Add(Surgery model)
{
OleDbParameter[] parameters = {
new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12),
new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar),
new OleDbParameter("@EmployeeID", OleDbType.VarWChar,18),
new OleDbParameter("@YearMonth", OleDbType.VarWChar,6),
new OleDbParameter("@Length", OleDbType.VarWChar,8),
new OleDbParameter("@Bust", OleDbType.VarWChar,8),
new OleDbParameter("@Weight", OleDbType.VarWChar,8),
new OleDbParameter("@BadBreath", OleDbType.VarWChar,50),
new OleDbParameter("@Skin", OleDbType.VarWChar,128),
new OleDbParameter("@Lymphoid", OleDbType.VarWChar,128),
new OleDbParameter("@Thyroid", OleDbType.VarWChar,128),
new OleDbParameter("@Spine", OleDbType.VarWChar,128),
new OleDbParameter("@Limbs", OleDbType.VarWChar,128),
new OleDbParameter("@Joint", OleDbType.VarWChar,128),
new OleDbParameter("@Flatfoot", OleDbType.VarWChar,128),
new OleDbParameter("@Genitourinary", OleDbType.VarWChar,128),
new OleDbParameter("@Anal", OleDbType.VarWChar,128),
new OleDbParameter("@Hernia", OleDbType.VarWChar,128),
new OleDbParameter("@Other", OleDbType.LongVarWChar),
new OleDbParameter("@MedicalAdvice", OleDbType.LongVarWChar),
new OleDbParameter("@Physicians", OleDbType.VarWChar,50)};
parameters[0].Value = model.UPDATER_ID;
parameters[1].Value = model.TERMINAL_CD;
parameters[2].Value = model.EmployeeID;
parameters[3].Value = model.YearMonth;
parameters[4].Value = model.Length;
parameters[5].Value = model.Bust;
parameters[6].Value = model.Weight;
parameters[7].Value = model.BadBreath;
parameters[8].Value = model.Skin;
parameters[9].Value = model.Lymphoid;
parameters[10].Value = model.Thyroid;
parameters[11].Value = model.Spine;
parameters[12].Value = model.Limbs;
parameters[13].Value = model.Joint;
parameters[14].Value = model.Flatfoot;
parameters[15].Value = model.Genitourinary;
parameters[16].Value = model.Anal;
parameters[17].Value = model.Hernia;
parameters[18].Value = model.Other;
parameters[19].Value = model.MedicalAdvice;
parameters[20].Value = model.Physicians;
return OleDbHelper.ExecuteSql(Add_SQL, parameters);
}
public ReturnValue AddUpdateSurgery(Surgery model)
{
BLL_Surgery bll = new BLL_Surgery();
return bll.AddUpdate(model);
}
public ReturnValue Update(Surgery model)
{
SqlParameter[] parametersUpdate = {
new SqlParameter("@UPDATER_ID", SqlDbType.NVarChar,12),
new SqlParameter("@TERMINAL_CD", SqlDbType.NVarChar,256),
new SqlParameter("@EmployeeID", SqlDbType.NVarChar,18),
new SqlParameter("@YearMonth", SqlDbType.NVarChar,6),
new SqlParameter("@Length", SqlDbType.NVarChar,8),
new SqlParameter("@Bust", SqlDbType.NVarChar,8),
new SqlParameter("@Weight", SqlDbType.NVarChar,8),
new SqlParameter("@BadBreath", SqlDbType.NVarChar,50),
new SqlParameter("@Skin", SqlDbType.NVarChar,128),
new SqlParameter("@Lymphoid", SqlDbType.NVarChar,128),
new SqlParameter("@Thyroid", SqlDbType.NVarChar,128),
new SqlParameter("@Spine", SqlDbType.NVarChar,128),
new SqlParameter("@Limbs", SqlDbType.NVarChar,128),
new SqlParameter("@Joint", SqlDbType.NVarChar,128),
new SqlParameter("@Flatfoot", SqlDbType.NVarChar,128),
new SqlParameter("@Genitourinary", SqlDbType.NVarChar,128),
new SqlParameter("@Anal", SqlDbType.NVarChar,128),
new SqlParameter("@Hernia", SqlDbType.NVarChar,128),
new SqlParameter("@Other", SqlDbType.NVarChar,256),
new SqlParameter("@MedicalAdvice", SqlDbType.NVarChar,1024),
new SqlParameter("@Physicians", SqlDbType.NVarChar,50)};
parametersUpdate[0].Value = model.UPDATER_ID;
parametersUpdate[1].Value = model.TERMINAL_CD;
parametersUpdate[2].Value = model.EmployeeID;
parametersUpdate[3].Value = model.YearMonth;
parametersUpdate[4].Value = model.Length;
parametersUpdate[5].Value = model.Bust;
parametersUpdate[6].Value = model.Weight;
parametersUpdate[7].Value = model.BadBreath;
parametersUpdate[8].Value = model.Skin;
parametersUpdate[9].Value = model.Lymphoid;
parametersUpdate[10].Value = model.Thyroid;
parametersUpdate[11].Value = model.Spine;
parametersUpdate[12].Value = model.Limbs;
parametersUpdate[13].Value = model.Joint;
parametersUpdate[14].Value = model.Flatfoot;
parametersUpdate[15].Value = model.Genitourinary;
parametersUpdate[16].Value = model.Anal;
parametersUpdate[17].Value = model.Hernia;
parametersUpdate[18].Value = model.Other;
parametersUpdate[19].Value = model.MedicalAdvice;
parametersUpdate[20].Value = model.Physicians;
return SqlHelper.ExecuteSql(Update_SQL, parametersUpdate);
}
