public void ToDataRow(NS_LuongCoBanInfo pNS_LuongCoBanInfo, ref DataRow dr)
{
dr[pNS_LuongCoBanInfo.strNS_LuongCoBanID] = pNS_LuongCoBanInfo.NS_LuongCoBanID;
dr[pNS_LuongCoBanInfo.strLuongCoBan] = pNS_LuongCoBanInfo.LuongCoBan;
dr[pNS_LuongCoBanInfo.strTuNgay] = pNS_LuongCoBanInfo.TuNgay;
dr[pNS_LuongCoBanInfo.strDenNgay] = pNS_LuongCoBanInfo.DenNgay;
}
public frmDM_LuongCoBan()
{
InitializeComponent();
oBNS_LuongCoBan = new cBNS_LuongCoBan();
pNS_LuongCoBanInfo = new NS_LuongCoBanInfo();
SetControl(false);
}
public void Delete(NS_LuongCoBanInfo pNS_LuongCoBanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_LuongCoBanID", SqlDbType.Int, pNS_LuongCoBanInfo.NS_LuongCoBanID));
RunProcedure("sp_NS_LuongCoBan_Delete", colParam);
}
public DataTable Get(NS_LuongCoBanInfo pNS_LuongCoBanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_LuongCoBanID", SqlDbType.Int, pNS_LuongCoBanInfo.NS_LuongCoBanID));
return(RunProcedureGet("sp_NS_LuongCoBan_Get", colParam));
}
public int Add_Update(NS_LuongCoBanInfo pNS_LuongCoBanInfo)
{
int ID = 0;
ID = oDNS_LuongCoBan.Add_Update(pNS_LuongCoBanInfo);
mErrorMessage = oDNS_LuongCoBan.ErrorMessages;
mErrorNumber = oDNS_LuongCoBan.ErrorNumber;
return(ID);
}
public int Add_Update(NS_LuongCoBanInfo pNS_LuongCoBanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@LuongCoBan", SqlDbType.Money, pNS_LuongCoBanInfo.LuongCoBan));
colParam.Add(CreateParam("@TuNgay", SqlDbType.DateTime, pNS_LuongCoBanInfo.TuNgay));
colParam.Add(CreateParam("@DenNgay", SqlDbType.DateTime, pNS_LuongCoBanInfo.DenNgay));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_NS_LuongCoBan_Add_Update", colParam));
}
public void Update(NS_LuongCoBanInfo pNS_LuongCoBanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@LuongCoBan", SqlDbType.Money, pNS_LuongCoBanInfo.LuongCoBan));
colParam.Add(CreateParam("@TuNgay", SqlDbType.DateTime, pNS_LuongCoBanInfo.TuNgay));
colParam.Add(CreateParam("@DenNgay", SqlDbType.DateTime, pNS_LuongCoBanInfo.DenNgay));
colParam.Add(CreateParam("@NS_LuongCoBanID", SqlDbType.Int, pNS_LuongCoBanInfo.NS_LuongCoBanID));
RunProcedure("sp_NS_LuongCoBan_Update", colParam);
}
public void ToInfo(ref NS_LuongCoBanInfo pNS_LuongCoBanInfo, DataRow dr)
{
pNS_LuongCoBanInfo.NS_LuongCoBanID = int.Parse(dr[pNS_LuongCoBanInfo.strNS_LuongCoBanID].ToString());
pNS_LuongCoBanInfo.LuongCoBan = double.Parse("0" + dr[pNS_LuongCoBanInfo.strLuongCoBan]);
if (dr[pNS_LuongCoBanInfo.strTuNgay].ToString() != "")
{
pNS_LuongCoBanInfo.TuNgay = DateTime.Parse(dr[pNS_LuongCoBanInfo.strTuNgay].ToString());
}
if (dr[pNS_LuongCoBanInfo.strDenNgay].ToString() != "")
{
pNS_LuongCoBanInfo.DenNgay = DateTime.Parse(dr[pNS_LuongCoBanInfo.strDenNgay].ToString());
}
}
public List <NS_LuongCoBanInfo> GetList(NS_LuongCoBanInfo pNS_LuongCoBanInfo)
{
List <NS_LuongCoBanInfo> oNS_LuongCoBanInfoList = new List <NS_LuongCoBanInfo>();
DataTable dtb = Get(pNS_LuongCoBanInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_LuongCoBanInfo = new NS_LuongCoBanInfo();
oNS_LuongCoBanInfo.NS_LuongCoBanID = int.Parse(dtb.Rows[i]["NS_LuongCoBanID"].ToString());
oNS_LuongCoBanInfo.LuongCoBan = double.Parse(dtb.Rows[i]["LuongCoBan"].ToString());
oNS_LuongCoBanInfo.TuNgay = DateTime.Parse(dtb.Rows[i]["TuNgay"].ToString());
oNS_LuongCoBanInfo.DenNgay = DateTime.Parse(dtb.Rows[i]["DenNgay"].ToString());
oNS_LuongCoBanInfoList.Add(oNS_LuongCoBanInfo);
}
}
return(oNS_LuongCoBanInfoList);
}
public void Delete(NS_LuongCoBanInfo pNS_LuongCoBanInfo)
{
oDNS_LuongCoBan.Delete(pNS_LuongCoBanInfo);
mErrorMessage = oDNS_LuongCoBan.ErrorMessages;
mErrorNumber = oDNS_LuongCoBan.ErrorNumber;
}
public DataTable Get(NS_LuongCoBanInfo pNS_LuongCoBanInfo)
{
return(oDNS_LuongCoBan.Get(pNS_LuongCoBanInfo));
}
