/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static OD_HANDOVER_Model getModel(OD_HANDOVER_SW sw) { DataTable dt = BaseDT.OD_HANDOVER.getDT(sw); DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { curOrgNo = sw.BYORGNO }); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { }); OD_HANDOVER_Model m = new OD_HANDOVER_Model(); if (dt.Rows.Count > 0) { int i = 0; m.ODHID = dt.Rows[i]["ODHID"].ToString(); m.ONDUTYDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["ONDUTYDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.ONDUTYUSERTYPE = dt.Rows[i]["ONDUTYUSERTYPE"].ToString(); m.ONDUTYTYPE = dt.Rows[i]["ONDUTYTYPE"].ToString(); m.ONDUTYUSERID = dt.Rows[i]["ONDUTYUSERID"].ToString(); m.OPTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["OPTIME"].ToString()); m.OPCONTENT = dt.Rows[i]["OPCONTENT"].ToString(); m.ONDUTYUSERName = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.ONDUTYUSERID); m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, dt.Rows[i]["BYORGNO"].ToString()); } dt.Clear(); dt.Dispose(); dtUser.Clear(); dtUser.Dispose(); dtORG.Clear(); dtORG.Dispose(); return(m); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在</returns> public static bool isExists(OD_HANDOVER_SW sw) { //ONDUTYDATE, BYORGNO, ONDUTYUSERTYPE, ONDUTYTYPE, ONDUTYUSERID, OPTIME, OPCONTENT StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from OD_HANDOVER where 1=1"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" and BYORGNO='{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } if (string.IsNullOrEmpty(sw.ODHID) == false) { sb.AppendFormat(" and ODHID='{0}'", ClsSql.EncodeSql(sw.ODHID)); } if (string.IsNullOrEmpty(sw.ONDUTYUSERTYPE) == false) { sb.AppendFormat(" and ONDUTYUSERTYPE='{0}'", ClsSql.EncodeSql(sw.ONDUTYUSERTYPE)); } if (string.IsNullOrEmpty(sw.ONDUTYTYPE) == false) { sb.AppendFormat(" and ONDUTYTYPE='{0}'", ClsSql.EncodeSql(sw.ONDUTYTYPE)); } if (string.IsNullOrEmpty(sw.ONDUTYUSERID) == false) { sb.AppendFormat(" and ONDUTYUSERID='{0}'", ClsSql.EncodeSql(sw.ONDUTYUSERID)); } if (string.IsNullOrEmpty(sw.ONDUTYDATE) == false) { sb.AppendFormat(" and ONDUTYDATE='{0}'", ClsSql.EncodeSql(sw.ONDUTYDATE)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 获取DT /// </summary> /// <param name="sw">参见OD_HANDOVER_SW</param> /// <returns>DT</returns> public static DataTable getDT(OD_HANDOVER_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT ODHID, ONDUTYDATE, BYORGNO, ONDUTYUSERTYPE, ONDUTYTYPE, ONDUTYUSERID, OPTIME, OPCONTENT FROM OD_HANDOVER"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" AND BYORGNO='{0}'", sw.BYORGNO); } if (string.IsNullOrEmpty(sw.ONDUTYDATE) == false) { sb.AppendFormat(" AND ONDUTYDATE='{0}'", sw.ONDUTYDATE); } if (string.IsNullOrEmpty(sw.ONDUTYUSERTYPE) == false) { sb.AppendFormat(" AND ONDUTYUSERTYPE='{0}'", sw.ONDUTYUSERTYPE); } if (string.IsNullOrEmpty(sw.ONDUTYTYPE) == false) { sb.AppendFormat(" AND ONDUTYTYPE='{0}'", sw.ONDUTYTYPE); } if (sw.isGetUPOne == "1")//获取上一班次交班信息 { sb.Clear(); sb.AppendFormat("SELECT top 1 ODHID, ONDUTYDATE, BYORGNO, ONDUTYUSERTYPE, ONDUTYTYPE, ONDUTYUSERID, OPTIME, OPCONTENT FROM OD_HANDOVER"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" AND BYORGNO='{0}'", sw.BYORGNO); } if (string.IsNullOrEmpty(sw.ONDUTYDATE) == false) { sb.AppendFormat(" AND ONDUTYDATE<='{0}'", sw.ONDUTYDATE); } if (string.IsNullOrEmpty(sw.ONDUTYTYPE) == false) { sb.AppendFormat(" AND ONDUTYTYPE='{0}'", sw.ONDUTYTYPE); } sb.AppendFormat(" AND ODHID not in(select ODHID from OD_HANDOVER where BYORGNO='{0}' AND ONDUTYDATE='{1}' AND ONDUTYUSERTYPE='{2}' )", sw.BYORGNO, sw.ONDUTYDATE, sw.ONDUTYUSERTYPE); sb.AppendFormat(" ORDER BY ONDUTYDATE DESC, ONDUTYUSERTYPE DESC", ""); } return(DataBaseClass.FullDataSet(sb.ToString()).Tables[0]); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static bool isExists(OD_HANDOVER_SW sw) { return(BaseDT.OD_HANDOVER.isExists(sw)); }