///<sumary> /// 通过主键获取数据对象 ///</sumary> /// <param name="RKEY">rkey</param> ///<returns>DATA0002对象</returns> public DATA0002 getDATA0002ByRKEY(decimal rkey) { #region SQL string sql = @"select top 1 isNull(rkey,0) as rkey , isNull(unit_code,'') as unit_code , isNull(unit_name,'') as unit_name , isNull(prod,'') as prod , isNull(purch,'') as purch , isNull(stock,'') as stock , isNull(quote,'') as quote , isNull(sell,'') as sell , isNull(unit_base,'') as unit_base , isNull(derived,'') as derived , isNull(int_check,'') as int_check , isNull(expression,'') as expression , isNull(min_unit_value,0) as min_unit_value , isNull(max_unit_value,0) as max_unit_value , isNull(unit_type,'') as unit_type , isNull(pot_outer_layer,0) as pot_outer_layer , isNull(pot_inner_layer,0) as pot_inner_layer , isNull(active_flag,0) as active_flag , isNull(ecn_flag,'') as ecn_flag from DATA0002 with (nolock) where RKEY='{0}'" ; #endregion ///定义返回对象 DATA0002 data0002 = null; #region 数据库操作 try { data0002 = new DATA0002(); using (DataTable tb = dbHelper.GetDataSet(string.Format(sql, rkey))) { foreach (DataRow row in tb.Rows) { data0002.RKEY = decimal.Parse(row["RKEY"].ToString()); data0002.UNIT_CODE = row["UNIT_CODE"].ToString(); data0002.UNIT_NAME = row["UNIT_NAME"].ToString(); data0002.PROD = row["PROD"].ToString(); data0002.PURCH = row["PURCH"].ToString(); data0002.STOCK = row["STOCK"].ToString(); data0002.QUOTE = row["QUOTE"].ToString(); data0002.SELL = row["SELL"].ToString(); data0002.UNIT_BASE = row["UNIT_BASE"].ToString(); data0002.DERIVED = row["DERIVED"].ToString(); data0002.INT_CHECK = row["INT_CHECK"].ToString(); data0002.EXPRESSION = row["EXPRESSION"].ToString(); data0002.MIN_UNIT_VALUE = decimal.Parse(row["MIN_UNIT_VALUE"].ToString()); data0002.MAX_UNIT_VALUE = decimal.Parse(row["MAX_UNIT_VALUE"].ToString()); data0002.UNIT_TYPE = row["UNIT_TYPE"].ToString(); data0002.POT_OUTER_LAYER = decimal.Parse(row["POT_OUTER_LAYER"].ToString()); data0002.POT_INNER_LAYER = decimal.Parse(row["POT_INNER_LAYER"].ToString()); data0002.ACTIVE_FLAG = decimal.Parse(row["ACTIVE_FLAG"].ToString()); data0002.ECN_FLAG = row["ECN_FLAG"].ToString(); } } } catch (Exception e) { //Console.WriteLine(e.Message); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";get function:" + e.Message, e); } #endregion return(data0002); }
///<sumary> /// 通过主键获取数据对象 ///</sumary> /// <param name="RKEY">rkey</param> ///<returns>DATA0073对象</returns> public DATA0073 getDATA0073ByRKEY(decimal rkey) { #region SQL string sql = @"select top 1 isNull(rkey,0) as rkey , isNull(user_id,'') as user_id , isNull(user_full_name,'') as user_full_name , isNull(user_login_name,'') as user_login_name , isNull(user_password,0) as user_password , isNull(user_station,0) as user_station , isNull(user_group_flag,0) as user_group_flag , isNull(language_flag,'') as language_flag , isNull(group_ptr,0) as group_ptr , isNull(def_printer_ptr,0) as def_printer_ptr , isNull(employee_ptr,0) as employee_ptr , isNull(network_id,'') as network_id , isNull(node_id,'') as node_id , isNull(session_id,0) as session_id from DATA0073 with (nolock) where RKEY='{0}'" ; #endregion ///定义返回对象 DATA0073 data0073 = null; #region 数据库操作 try { data0073 = new DATA0073(); using (DataTable tb = dbHelper.GetDataSet(string.Format(sql, rkey))) { foreach (DataRow row in tb.Rows) { data0073.RKEY = decimal.Parse(row["RKEY"].ToString()); data0073.USER_ID = row["USER_ID"].ToString(); data0073.USER_FULL_NAME = row["USER_FULL_NAME"].ToString(); data0073.USER_LOGIN_NAME = row["USER_LOGIN_NAME"].ToString(); data0073.USER_PASSWORD = (Byte[])(row["USER_PASSWORD"]); data0073.USER_STATION = decimal.Parse(row["USER_STATION"].ToString()); data0073.USER_GROUP_FLAG = decimal.Parse(row["USER_GROUP_FLAG"].ToString()); data0073.LANGUAGE_FLAG = row["LANGUAGE_FLAG"].ToString(); data0073.GROUP_PTR = decimal.Parse(row["GROUP_PTR"].ToString()); data0073.DEF_PRINTER_PTR = decimal.Parse(row["DEF_PRINTER_PTR"].ToString()); data0073.EMPLOYEE_PTR = decimal.Parse(row["EMPLOYEE_PTR"].ToString()); data0073.NETWORK_ID = row["NETWORK_ID"].ToString(); data0073.NODE_ID = row["NODE_ID"].ToString(); data0073.SESSION_ID = decimal.Parse(row["SESSION_ID"].ToString()); } } } catch (Exception e) { //Console.WriteLine(e.Message); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";get function:" + e.Message, e); } #endregion return(data0073); }
///<sumary> /// 通过主键获取数据对象 ///</sumary> /// <param name="RKEY">rkey</param> ///<returns>FOUNDERPCB_USER对象</returns> public FOUNDERPCB_USER getFOUNDERPCB_USERByRKEY(decimal rkey) { #region SQL string sql = @"select top 1 isNull(rkey,0) as rkey , isNull(login_id,'') as login_id , isNull(pro_rkey,0) as pro_rkey , isNull(name,'') as name , isNull(dept,'') as dept , isNull(position,'') as position , isNull(tel_number,'') as tel_number , isNull(mobile,'') as mobile , isNull(addr,'') as addr , isNull(data0073rkey,0) as data0073rkey , isNull(role,0) as role , isNull(sys_version,'') as sys_version , isNull(create_date,'1900-1-1') as create_date from FOUNDERPCB_USER with (nolock) where RKEY='{0}'" ; #endregion ///定义返回对象 FOUNDERPCB_USER founderpcb_user = null; #region 数据库操作 try { founderpcb_user = new FOUNDERPCB_USER(); using (DataTable tb = dbHelper.GetDataSet(string.Format(sql, rkey))) { foreach (DataRow row in tb.Rows) { founderpcb_user.RKEY = decimal.Parse(row["RKEY"].ToString()); founderpcb_user.LOGIN_ID = row["LOGIN_ID"].ToString(); founderpcb_user.PRO_RKEY = decimal.Parse(row["PRO_RKEY"].ToString()); founderpcb_user.NAME = row["NAME"].ToString(); founderpcb_user.DEPT = row["DEPT"].ToString(); founderpcb_user.POSITION = row["POSITION"].ToString(); founderpcb_user.TEL_NUMBER = row["TEL_NUMBER"].ToString(); founderpcb_user.MOBILE = row["MOBILE"].ToString(); founderpcb_user.ADDR = row["ADDR"].ToString(); founderpcb_user.DATA0073RKEY = decimal.Parse(row["DATA0073RKEY"].ToString()); founderpcb_user.ROLE = int.Parse(row["ROLE"].ToString()); founderpcb_user.SYS_VERSION = row["SYS_VERSION"].ToString(); founderpcb_user.CREATE_DATE = DateTime.Parse(row["CREATE_DATE"].ToString()); } } } catch (Exception e) { //Console.WriteLine(e.Message); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";get function:" + e.Message, e); } #endregion return(founderpcb_user); }
///<sumary> /// 通过主键获取数据对象 ///</sumary> /// <param name="RKEY">rkey</param> ///<returns>DATA0005对象</returns> public DATA0005 getDATA0005ByRKEY(decimal rkey) { #region SQL string sql = @"select top 1 isNull(rkey,0) as rkey , isNull(empl_code,'') as empl_code , isNull(employee_name,'') as employee_name , isNull(abbr_name,'') as abbr_name , isNull(employee_id,'') as employee_id , isNull(address_line_1,'') as address_line_1 , isNull(address_line_2,'') as address_line_2 , isNull(address_line_3,'') as address_line_3 , isNull(state,'') as state , isNull(zip,'') as zip , isNull(phone,'') as phone , isNull(note_pad_pointer,0) as note_pad_pointer , isNull(pay_rate_1,0) as pay_rate_1 , isNull(pay_rate_2,0) as pay_rate_2 , isNull(pay_rate_3,0) as pay_rate_3 , isNull(start_time_1,0) as start_time_1 , isNull(start_time_2,0) as start_time_2 , isNull(start_time_3,0) as start_time_3 , isNull(active_flag,'') as active_flag , isNull(buyer_flag,'') as buyer_flag , isNull(inactive_date,'1900-1-1') as inactive_date , isNull(tpostion,'') as tpostion , isNull(email,'') as email , isNull(empl_password,0) as empl_password from DATA0005 with (nolock) where RKEY='{0}'" ; #endregion ///定义返回对象 DATA0005 data0005 = null; #region 数据库操作 try { data0005 = new DATA0005(); using (DataTable tb = dbHelper.GetDataSet(string.Format(sql, rkey))) { foreach (DataRow row in tb.Rows) { data0005.RKEY = decimal.Parse(row["RKEY"].ToString()); data0005.EMPL_CODE = row["EMPL_CODE"].ToString(); data0005.EMPLOYEE_NAME = row["EMPLOYEE_NAME"].ToString(); data0005.ABBR_NAME = row["ABBR_NAME"].ToString(); data0005.EMPLOYEE_ID = row["EMPLOYEE_ID"].ToString(); data0005.ADDRESS_LINE_1 = row["ADDRESS_LINE_1"].ToString(); data0005.ADDRESS_LINE_2 = row["ADDRESS_LINE_2"].ToString(); data0005.ADDRESS_LINE_3 = row["ADDRESS_LINE_3"].ToString(); data0005.STATE = row["STATE"].ToString(); data0005.ZIP = row["ZIP"].ToString(); data0005.PHONE = row["PHONE"].ToString(); data0005.NOTE_PAD_POINTER = decimal.Parse(row["NOTE_PAD_POINTER"].ToString()); data0005.PAY_RATE_1 = decimal.Parse(row["PAY_RATE_1"].ToString()); data0005.PAY_RATE_2 = decimal.Parse(row["PAY_RATE_2"].ToString()); data0005.PAY_RATE_3 = decimal.Parse(row["PAY_RATE_3"].ToString()); data0005.START_TIME_1 = decimal.Parse(row["START_TIME_1"].ToString()); data0005.START_TIME_2 = decimal.Parse(row["START_TIME_2"].ToString()); data0005.START_TIME_3 = decimal.Parse(row["START_TIME_3"].ToString()); data0005.ACTIVE_FLAG = row["ACTIVE_FLAG"].ToString(); data0005.BUYER_FLAG = row["BUYER_FLAG"].ToString(); data0005.INACTIVE_DATE = DateTime.Parse(row["INACTIVE_DATE"].ToString()); data0005.TPOSTION = row["TPOSTION"].ToString(); data0005.EMAIL = row["EMAIL"].ToString(); data0005.EMPL_PASSWORD = (Byte[])(row["EMPL_PASSWORD"]); } } } catch (Exception e) { //Console.WriteLine(e.Message); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";get function:" + e.Message, e); } #endregion return(data0005); }