/// <summary>
/// 保存操作，（更新删除添加）
/// add by ywk
/// </summary>
/// <param name="patStateEnt"></param>
/// <param name="edittype"></param>
public static string SaveStateData(PatStateEntity patStateEnt, string edittype)
{
try
{
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@EditType", SqlDbType.VarChar),
new SqlParameter("@CCode", SqlDbType.VarChar),
new SqlParameter("@ID", SqlDbType.VarChar),
new SqlParameter("@NoofInPat", SqlDbType.VarChar),
new SqlParameter("@DoTime", SqlDbType.VarChar),
new SqlParameter("@Patid", SqlDbType.VarChar)
};
sqlParam[0].Value = edittype;
sqlParam[1].Value = patStateEnt.CCODE;
sqlParam[2].Value = patStateEnt.ID;
sqlParam[3].Value = patStateEnt.NOOFINPAT;
sqlParam[4].Value = patStateEnt.DOTIME;
sqlParam[5].Value = patStateEnt.PATID;
return(sql_Helper.ExecuteDataSet("EMRPROC.usp_Edit_PatStates", sqlParam, CommandType.StoredProcedure).Tables[0].Rows[0][0].ToString());
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(ex.Message);
return("");
}
}
/// <summary>
/// 保存操作，（更新删除添加）
/// add by ywk
/// </summary>
/// <param name="patStateEnt"></param>
/// <param name="edittype"></param>
public static string SaveStateData(PatStateEntity patStateEnt, string edittype)
{
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@EditType", SqlDbType.VarChar),
new SqlParameter("@CCode", SqlDbType.VarChar),
new SqlParameter("@ID", SqlDbType.VarChar),
new SqlParameter("@NoofInPat", SqlDbType.VarChar),
new SqlParameter("@DoTime", SqlDbType.VarChar)
};
sqlParam[0].Value = edittype;
sqlParam[1].Value = patStateEnt.CCODE;
sqlParam[2].Value = patStateEnt.ID;
sqlParam[3].Value = patStateEnt.PATID;
sqlParam[4].Value = patStateEnt.DOTIME;
return(sql_Helper.ExecuteDataSet("EMRPROC.usp_Edit_PatStates", sqlParam, CommandType.StoredProcedure).Tables[0].Rows[0][0].ToString());
}