// dbCmd.Parameters.Add(new SqlParameter("@CusName", data.CusName)); public static void Insert(tbBill_CustomerInfo tbBill_Customer) { string q = "insert into [tbBill_Customers] ([CuIsd],[totalmoney],[idate],[xdate],[request],"; q = q + "[typepay],[state],[lang],[show])values(@CusId,@totalmoney,@idate,"; q = q + "@xdate,@request,@typepay,@state,@lang,@show)"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; cmd.Connection = GetConnection(); cmd.Parameters.Add(new SqlParameter("@CusId", tbBill_Customer.CusId)); cmd.Parameters.Add(new SqlParameter("@totalmoney", tbBill_Customer.Totalmoney)); cmd.Parameters.Add(new SqlParameter("@idate", tbBill_Customer.Idate)); cmd.Parameters.Add(new SqlParameter("@xdate", tbBill_Customer.Xdate)); cmd.Parameters.Add(new SqlParameter("@request", tbBill_Customer.Request)); cmd.Parameters.Add(new SqlParameter("@typepay", tbBill_Customer.Typepay)); cmd.Parameters.Add(new SqlParameter("@state", tbBill_Customer.State)); cmd.Parameters.Add(new SqlParameter("@lang", tbBill_Customer.Lang)); cmd.Parameters.Add(new SqlParameter("@show", tbBill_Customer.Show)); ExecuteNonQuery(cmd); }
public static void Update(tbBill_CustomerInfo tbBill_Customer) { string q = "update [tbBill_Customers] set [CusId] = @CusId,[totalmoney] = @totalmoney,"; q = q + "[idate] = @idate,[xdate] = @xdate,[request] = @request,[typepay] = @typepay,[state] = @state,"; q = q + "[lang] = @lang,[show] = @show where Id = @Id"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; cmd.Connection = GetConnection(); cmd.Parameters.Add(new SqlParameter("@CusId", tbBill_Customer.CusId)); cmd.Parameters.Add(new SqlParameter("@totalmoney", tbBill_Customer.Totalmoney)); cmd.Parameters.Add(new SqlParameter("@idate", tbBill_Customer.Idate)); cmd.Parameters.Add(new SqlParameter("@xdate", tbBill_Customer.Xdate)); cmd.Parameters.Add(new SqlParameter("@request", tbBill_Customer.Request)); cmd.Parameters.Add(new SqlParameter("@typepay", tbBill_Customer.Typepay)); cmd.Parameters.Add(new SqlParameter("@state", tbBill_Customer.State)); cmd.Parameters.Add(new SqlParameter("@lang", tbBill_Customer.Lang)); cmd.Parameters.Add(new SqlParameter("@show", tbBill_Customer.Show)); cmd.Parameters.Add(new SqlParameter("@Id", tbBill_Customer.Id)); ExecuteNonQuery(cmd); }
public static DataTable GetBy_Id(tbBill_CustomerInfo Bill_Customer) { string str = "select * from [tbBill_Customers] where [Id]=" + Bill_Customer.Id; return(GetData(str)); }