public static A2ZTRNOPTDTO GetInformation(int Typecode, int functOpt, int PayType)
{
var prm = new object[3];
prm[0] = Typecode;
prm[1] = functOpt;
prm[2] = PayType;
DataTable dt = BLL.CommonManager.Instance.GetDataTableBySpWithParams("Sp_CSGetInfoTrnOpt", prm, "A2ZCSMCUS");
//DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZTRNOPT WHERE AccType='" + Typecode + "' and PayType='" + PayType + "' and FuncOpt='" + functOpt + "'", "A2ZCSMCUS");
var p = new A2ZTRNOPTDTO();
if (dt.Rows.Count > 0)
{
p.AccType = Converter.GetInteger(dt.Rows[0]["AccType"]);
p.FunctionOption = Converter.GetInteger(dt.Rows[0]["FuncOpt"]);
p.PayType = Converter.GetInteger(dt.Rows[0]["PayType"]);
p.TrnType = Converter.GetInteger(dt.Rows[0]["TrnType"]);
p.TrnMode = Converter.GetInteger(dt.Rows[0]["TrnMode"]);
p.TrnAmtLogic = Converter.GetInteger(dt.Rows[0]["TrnLogic"]);
p.TrnValidation = Converter.GetInteger(dt.Rows[0]["TrnValidation"]);
p.AccTypeDes = Converter.GetString(dt.Rows[0]["AccTypeDes"]);
p.Record = Converter.GetInteger(1);
return(p);
}
p.AccType = 0;
p.Record = 0;
return(p);
}
public static int InsertInformation(A2ZTRNOPTDTO dto)
{
int rowEffect = 0;
string strQuery = @"INSERT into A2ZTRNOPT(AccType,AccTypeDes,FuncOpt,PayType,TrnType,TrnMode,TrnLogic,TrnValidation)values('" + dto.AccType + "','" + dto.AccTypeDes + "','" +
dto.FunctionOption + "','" + dto.PayType + "','" + dto.TrnType + "','" + dto.TrnMode + "','" + dto.TrnAmtLogic + "','" + dto.TrnValidation + "')";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static int UpdateInformation(A2ZTRNOPTDTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE A2ZTRNOPT set AccType='" + dto.AccType + "', AccTypeDes='" + dto.AccTypeDes + "', FuncOpt='" + dto.FunctionOption + "',PayType='" +
dto.PayType + "',TrnType='" + dto.TrnType + "',TrnMode='" + dto.TrnMode + "',TrnLogic='" +
dto.TrnAmtLogic + "',TrnValidation='" + dto.TrnValidation + "' where AccType='" +
dto.AccType + "' and funcOpt='" + dto.FunctionOption + "' and PayType='" + dto.PayType + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}