public LCOutput Get(string data)
{
outPut.Clear();
try
{
KMQueryQC queryQC = Newtonsoft.Json.JsonConvert.DeserializeObject <KMQueryQC>(data);
outPut.data = new DBKeyMan().Get(queryQC);
}
catch (Exception ex)
{
outPut.result = 1;
outPut.resultStr = ex.Message.ToString();
}
return(outPut);
}
public List <KeyMan> GetHistory(KMQueryQC queryQC)
{
return(InnerGet(queryQC, "tab_keyTrainman_His"));
}
private List <KeyMan> InnerGet(KMQueryQC queryQC, string TableName)
{
List <KeyMan> ret = new List <KeyMan>();
string sql = "select * from " + TableName + " where 1=1 ";
if (!string.IsNullOrEmpty(queryQC.WorkShopGUID))
{
sql += " and strWorkShopGUID = @strWorkShopGUID";
}
if (!string.IsNullOrEmpty(queryQC.CheDuiGUID))
{
sql += " and strCheJianGUID = @strCheJianGUID";
}
if (!string.IsNullOrEmpty(queryQC.KeyTMNumber))
{
sql += " and strTrainmanNumber = @strTrainmanNumber";
}
if (!string.IsNullOrEmpty(queryQC.KeyTMName))
{
sql += " and strTrainmanName = @strTrainmanName";
}
if (queryQC.RegisterEndTime != null)
{
sql += " and dtRegisterTime >= @dtRegisterStartTime";
}
if (queryQC.RegisterStartTime != null)
{
sql += " and dtRegisterTime <= @dtRegisterEndTime";
}
sql += " order by dtRegisterTime desc,eOpt desc";
DbParamDict dbParamDict = new DbParamDict();
dbParamDict.Add("strWorkShopGUID", queryQC.WorkShopGUID, ParamDataType.dtString);
dbParamDict.Add("strCheJianGUID", queryQC.CheDuiGUID, ParamDataType.dtString);
dbParamDict.Add("strTrainmanNumber", queryQC.KeyTMNumber, ParamDataType.dtString);
dbParamDict.Add("strTrainmanName", queryQC.KeyTMName, ParamDataType.dtString);
dbParamDict.Add("dtRegisterStartTime", queryQC.RegisterStartTime, ParamDataType.dtDateTime);
dbParamDict.Add("dtRegisterEndTime", queryQC.RegisterEndTime, ParamDataType.dtDateTime);
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, dbParamDict.GetParams()).Tables[0];
KeyMan keyman;
foreach (DataRow dr in dt.Rows)
{
keyman = new KeyMan();
keyman.ID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
keyman.KeyAnnouncements = ObjectConvertClass.static_ext_string(dr["strAnnouncements"]);
keyman.KeyEndTime = ObjectConvertClass.static_ext_date(dr["dtEndTime"]);
keyman.KeyReason = ObjectConvertClass.static_ext_string(dr["strReason"]);
keyman.KeyStartTime = ObjectConvertClass.static_ext_date(dr["dtStartTime"]);
keyman.KeyTMCheDuiGUID = ObjectConvertClass.static_ext_string(dr["strCheJianGUID"]);
keyman.KeyTMCheDuiName = ObjectConvertClass.static_ext_string(dr["strCheJianName"]);
keyman.KeyTMName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
keyman.KeyTMNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
keyman.KeyTMWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
keyman.KeyTMWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
keyman.RegisterName = ObjectConvertClass.static_ext_string(dr["strRegisterName"]);
keyman.RegisterNumber = ObjectConvertClass.static_ext_string(dr["strRegisterNumber"]);
keyman.RegisterTime = ObjectConvertClass.static_ext_date(dr["dtRegisterTime"]);
keyman.ClientNumber = ObjectConvertClass.static_ext_string(dr["strClientNumber"]);
keyman.ClientName = ObjectConvertClass.static_ext_string(dr["strClientName"]);
keyman.eOpt = ObjectConvertClass.static_ext_int(dr["eOpt"]);
ret.Add(keyman);
}
return(ret);
}