public static int InsertInformation(A2ZREPORTLAYOUTDTO dto)
{
int rowEffect = 0;
string strQuery = "INSERT INTO A2ZREPORTLAYOUT(RepDate,RepColumn,RepColumnName,RepColumnFlag,RepColumnCode,Status)VALUES('" + dto.RepDate + "','" + dto.RepColumn + "','" + dto.RepColumnName + "','" + dto.RepColumnFlag + "','" + dto.RepColumnCode + "','" + dto.Status + "')";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS"));
if (rowEffect == 0)
{
return(0);
}
return(1);
}
public static A2ZREPORTLAYOUTDTO GetInformation(int RepColumn, DateTime RepDate)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery(
"SELECT * FROM A2ZREPORTLAYOUT WHERE RepColumn = '" + RepColumn + "' AND RepDate='" + RepDate + "'", "A2ZHRMCUS");
var p = new A2ZREPORTLAYOUTDTO();
if (dt.Rows.Count > 0)
{
p.ID = Converter.GetSmallInteger(dt.Rows[0]["ID"]);
p.RepColumn = Converter.GetInteger(dt.Rows[0]["RepColumn"]);
p.RepColumnName = Converter.GetString(dt.Rows[0]["RepColumnName"]);
p.RepColumnFlag = Converter.GetSmallInteger(dt.Rows[0]["RepColumnFlag"]);
p.Status = Converter.GetSmallInteger(dt.Rows[0]["Status"]);
p.RepColumnCode = Converter.GetInteger(dt.Rows[0]["RepColumnCode"]);
return(p);
}
p.RepColumn = 0;
return(p);
}
