public static int insert(ClAgreementBill c ) { SqlCommand cmd = new SqlCommand("PRC_AgreementBill_Insert", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID(); cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress(); cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS(); cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion(); cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL(); cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value =Securenamespace.SecureData.CheckSecurity(c.AgreementID); cmd.Parameters.Add(new SqlParameter("MonthID", SqlDbType.Int)).Value =Securenamespace.SecureData.CheckSecurity(c.MonthID); cmd.Parameters.Add(new SqlParameter("BillPrice", SqlDbType.Int)).Value =Securenamespace.SecureData.CheckSecurity(c.BillPrice); cmd.Parameters.Add(new SqlParameter("SYSDate", SqlDbType.NVarChar)).Value =Securenamespace.SecureData.CheckSecurity(c.SYSDate); cmd.Parameters.Add(new SqlParameter("SYSUser", SqlDbType.Int)).Value =Securenamespace.SecureData.CheckSecurity(c.SYSUser); SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int); prmResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(prmResult); try { cnn.Open(); cmd.ExecuteNonQuery(); return Convert.ToInt32(prmResult.Value); } catch (Exception ex) { return 0; } finally { cnn.Close(); } }
//--------------------------------------------------------------------------------------------------------- public static DataSet GetList(ClAgreementBill c) { SqlCommand cmd = new SqlCommand("PRC_AgreementBill_GetList", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID(); cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress(); cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS(); cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion(); cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL(); cmd.Parameters.Add(new SqlParameter("AgreementBillID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementBillID); cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID); cmd.Parameters.Add(new SqlParameter("MonthID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.MonthID); cmd.Parameters.Add(new SqlParameter("BillPrice", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.BillPrice); cmd.Parameters.Add(new SqlParameter("SYSDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.SYSDate); cmd.Parameters.Add(new SqlParameter("SYSUser", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SYSUser); SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int); prmResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(prmResult); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); try { cnn.Open(); da.Fill(ds); return ds; } catch (Exception ex) { return null; } finally { cnn.Close(); } }