public string usp_zlk_Make_Ins(string MakeName) { DataMaven dm = new DataMaven(); dm.SetSP("usp_zlk_Make_Ins"); dm.AddParameter("@MakeName", SqlDbType.VarChar, ParameterDirection.Input, MakeName); dm.AddParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, Util.LoggedInUser()); dm.AddParameter("@NewID", SqlDbType.Int, ParameterDirection.Output, null); SqlParameterCollection parms = dm.ExecNonQuery(); return(parms["@NewID"].Value.ToString()); }
protected int BusinessDayCount(DateTime StartDate, DateTime EndDate) { DataMaven dm = new DataMaven(); dm.SetSP("usp_BusinessDayCount_Sel"); dm.AddParameter("@StartDate", SqlDbType.DateTime, ParameterDirection.Input, StartDate); dm.AddParameter("@EndDate", SqlDbType.DateTime, ParameterDirection.Input, EndDate); dm.AddParameter("@DayCount", SqlDbType.Int, ParameterDirection.Output, null); SqlParameterCollection parms = dm.ExecNonQuery(); return((int)parms["@DayCount"].Value); }
public static void LoadList(RadioButtonList rdo, string sp, string TextField, string ValueField, string[,] Parms = null) { try { DataMaven dm = new DataMaven(); System.Data.SqlDbType dType = default(System.Data.SqlDbType); DataTable dt = null; int i = 0; dm.SetSP(sp); if ((Parms != null)) { for (i = 0; i <= Parms.GetUpperBound(1); i++) { if ((Parms != null)) { dType = (SqlDbType)Parms.GetValue(i, 0); dm.AddParameter(Parms.GetValue(i, 1).ToString(), dType, ParameterDirection.Input, Parms.GetValue(i, 2)); } } } dt = dm.ExecToDataTable(); // Bind data to RadioButtonList rdo.DataSource = dt; rdo.DataTextField = TextField; rdo.DataValueField = ValueField; rdo.DataBind(); } catch (Exception ex) { // Display error message Util.jsErrorAlert(ex.Message); } }