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);
}
