public static int UpdateInformation(A2ZDEDCTRLDTO dto) { int rowEffect = 0; string strQuery = "UPDATE A2ZDEDCTRL set dependsOn='" + dto.DependsOn + "', Location='" + dto.Location + "', Percentage='" + dto.Percentage + "', ServType='" + dto.ServType + "', Religion='" + dto.Religion + "' where DedCode='" + dto.DedCode + "'"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static int InsertInformation(A2ZDEDCTRLDTO dto) { int rowEffect = 0; string strQuery = @"INSERT into A2ZDEDCTRL(DedCode,DedDesc,DependsOn,Location, Percentage,ServType,Religion) values('" + dto.DedCode + "','" + dto.DedDesc + "','" + dto.DependsOn + "','" + dto.Location + "','" + dto.Percentage + "','" + dto.ServType + "','" + dto.Religion + "')"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static A2ZDEDCTRLDTO GetInformation(int DedCode) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZDEDCTRL WHERE DedCode = '" + DedCode + "'", "A2ZHRMCUS"); var p = new A2ZDEDCTRLDTO(); if (dt.Rows.Count > 0) { p.DedCode = Converter.GetInteger(dt.Rows[0]["DedCode"]); p.DedDesc = Converter.GetString(dt.Rows[0]["DedDesc"]); p.DependsOn = Converter.GetInteger(dt.Rows[0]["DependsOn"]); p.Location = Converter.GetBoolean(dt.Rows[0]["Location"]); p.Percentage = Converter.GetBoolean(dt.Rows[0]["Percentage"]); p.ServType = Converter.GetBoolean(dt.Rows[0]["ServType"]); p.Religion = Converter.GetBoolean(dt.Rows[0]["Religion"]); return(p); } p.DedCode = 0; return(p); }