internal B2b_company_pos GetPosByPosId(string pos_id)
{
const string sqlTxt = @"SELECT [id]
,[com_id]
,[poscompany]
,[posid]
,[BindingTime]
,[admin]
,[Remark]
FROM [EtownDB].[dbo].[b2b_company_pos] where posid=@posid";
var cmd = sqlHelper.PrepareTextSqlCommand(sqlTxt);
cmd.AddParam("@posid", pos_id);
using (var reader = cmd.ExecuteReader())
{
B2b_company_pos u = null;
while (reader.Read())
{
u = new B2b_company_pos
{
Id = reader.GetValue <int>("id"),
Com_id = reader.GetValue <int>("com_id"),
Poscompany = reader.GetValue <string>("poscompany"),
Posid = reader.GetValue <int>("posid"),
BindingTime = reader.GetValue <DateTime>("BindingTime"),
Admin = reader.GetValue <string>("admin"),
Remark = reader.GetValue <string>("Remark")
};
}
return(u);
}
}
public B2b_company_pos GetPosByPosId(string pos_id)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalB2bCompanyPos(sql);
B2b_company_pos result = internalData.GetPosByPosId(pos_id);
return(result);
}
catch
{
throw;
}
}
}