public Companys_costlogInfo GetModel(int id) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" from Companys_costlog "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Companys_costlogInfo info = new Companys_costlogInfo(); using (SqlDataReader dr = SqlDbHelper.ExecuteReader(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters)) { if (dr.Read()) { info = GetInfoByDr(dr); } } return(info); } catch { } return(null); }
public List <Companys_costlogInfo> GetList(int Top, string strWhere, string filedOrder) { List <Companys_costlogInfo> list = new List <Companys_costlogInfo>(); try { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" * "); strSql.Append(" FROM Companys_costlog "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } if (filedOrder.Trim() != "") { strSql.Append(" order by " + filedOrder); } using (SqlDataReader dr = SqlDbHelper.ExecuteReader(Config.SqlConnection, strSql.ToString(), CommandType.Text)) { while (dr.Read()) { Companys_costlogInfo info = GetInfoByDr(dr); list.Add(info); } } return(list); } catch { } return(null); }
private Companys_costlogInfo GetInfoByDr(SqlDataReader dr) { Companys_costlogInfo info = new Companys_costlogInfo(); info.id = int.Parse(dr["id"] != DBNull.Value ? dr["id"].ToString() : "0"); info.userid = int.Parse(dr["userid"] != DBNull.Value ? dr["userid"].ToString() : "0"); info.companyid = int.Parse(dr["companyid"] != DBNull.Value ? dr["companyid"].ToString() : "0"); info.amount = decimal.Parse(dr["amount"] != DBNull.Value ? dr["amount"].ToString() : "0"); info.description = dr["description"] != DBNull.Value ? dr["description"].ToString() : ""; info.createtime = DateTime.Parse(dr["createtime"] != DBNull.Value ? dr["createtime"].ToString() : ""); return(info); }
public int updatetotalamount(decimal totalamount, int CompanyID, ref string resultMsg) { SqlConnection con = new SqlConnection(); con.ConnectionString = Config.SqlConnection; con.Open(); // 启动一个事务。 SqlTransaction myTran = con.BeginTransaction(); SqlCommand com = new SqlCommand(); com.Connection = con; com.Transaction = myTran; try { int result = updatetotalamount(com, totalamount, CompanyID, ref resultMsg); if (result <= 0) { myTran.Rollback(); return(result); } Companys_costlogInfo cloginfo = new Companys_costlogInfo(); cloginfo.userid = 0; cloginfo.companyid = CompanyID; cloginfo.amount = totalamount; cloginfo.description = "充值"; cloginfo.createtime = DateTime.Now; string resultstr = ""; int addlog = new Companys_costlogDAL().Add(cloginfo, ref resultstr); if (addlog <= 0) { myTran.Rollback(); return(0); } myTran.Commit(); return(result); } catch (Exception exc) { resultMsg = exc.Message; myTran.Rollback(); } finally { com.Dispose(); con.Close(); } return(0); }
public int Add(SqlCommand com, Companys_costlogInfo model, ref string resultMsg) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Companys_costlog("); strSql.Append("userid,companyid,amount,description,createtime"); strSql.Append(") values ("); strSql.Append("@userid,@companyid,@amount,@description,@createtime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); com.Parameters.Clear(); com.Parameters.Add("@userid", SqlDbType.Int, 4); com.Parameters.Add("@companyid", SqlDbType.Int, 4); com.Parameters.Add("@amount", SqlDbType.Money, 8); com.Parameters.Add("@description", SqlDbType.NVarChar, 255); com.Parameters.Add("@createtime", SqlDbType.DateTime); com.Parameters[5].Value = model.userid; com.Parameters[6].Value = model.companyid; com.Parameters[7].Value = model.amount; com.Parameters[8].Value = model.description; com.Parameters[9].Value = model.createtime; com.CommandText = strSql.ToString(); com.CommandType = CommandType.Text; object obj = com.ExecuteScalar(); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } } catch (Exception exc) { resultMsg = exc.Message; } return(0); }
public int Add(Companys_costlogInfo model, ref string resultMsg) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Companys_costlog("); strSql.Append("userid,companyid,amount,description,createtime"); strSql.Append(") values ("); strSql.Append("@userid,@companyid,@amount,@description,@createtime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@companyid", SqlDbType.Int, 4), new SqlParameter("@amount", SqlDbType.Money, 8), new SqlParameter("@description", SqlDbType.NVarChar, 255), new SqlParameter("@createtime", SqlDbType.DateTime) }; parameters[0].Value = model.userid; parameters[1].Value = model.companyid; parameters[2].Value = model.amount; parameters[3].Value = model.description; parameters[4].Value = model.createtime; object obj = SqlDbHelper.ExecuteScalar(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } } catch (Exception exc) { resultMsg = exc.Message; } return(0); }
public int Update(Companys_costlogInfo model, ref string resultMsg) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update Companys_costlog set "); strSql.Append(" userid = @userid , "); strSql.Append(" companyid = @companyid , "); strSql.Append(" amount = @amount , "); strSql.Append(" description = @description , "); strSql.Append(" createtime = @createtime "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@companyid", SqlDbType.Int, 4), new SqlParameter("@amount", SqlDbType.Money, 8), new SqlParameter("@description", SqlDbType.NVarChar, 255), new SqlParameter("@createtime", SqlDbType.DateTime) }; parameters[0].Value = model.id; parameters[1].Value = model.userid; parameters[2].Value = model.companyid; parameters[3].Value = model.amount; parameters[4].Value = model.description; parameters[5].Value = model.createtime; int rows = SqlDbHelper.ExecuteNonQuery(Config.SqlConnection, strSql.ToString(), CommandType.Text, parameters); return(rows); } catch (Exception exc) { resultMsg = exc.Message; } return(0); }