///<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);
}
