/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.fms_kuan_adjust DataRowToModel(DataRow row)
{
FMS_Model.fms_kuan_adjust model = new FMS_Model.fms_kuan_adjust();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["date_time"] != null && row["date_time"].ToString() != "")
{
model.date_time = int.Parse(row["date_time"].ToString());
}
if (row["customer_id"] != null && row["customer_id"].ToString() != "")
{
model.customer_id = int.Parse(row["customer_id"].ToString());
}
if (row["user_id"] != null && row["user_id"].ToString() != "")
{
model.user_id = int.Parse(row["user_id"].ToString());
}
if (row["change_total"] != null && row["change_total"].ToString() != "")
{
model.change_total = decimal.Parse(row["change_total"].ToString());
}
if (row["change_type"] != null && row["change_type"].ToString() != "")
{
model.change_type = int.Parse(row["change_type"].ToString());
}
if (row["change_desc"] != null)
{
model.change_desc = row["change_desc"].ToString();
}
if (row["admin_id"] != null)
{
model.admin_id = row["admin_id"].ToString();
}
if (row["erp_dakuanhao"] != null)
{
model.erp_dakuanhao = row["erp_dakuanhao"].ToString();
}
if (row["erp_time"] != null && row["erp_time"].ToString() != "")
{
model.erp_time = int.Parse(row["erp_time"].ToString());
}
if (row["status"] != null && row["status"].ToString() != "")
{
model.status = int.Parse(row["status"].ToString());
}
if (row["adjust_sn"] != null)
{
model.adjust_sn = row["adjust_sn"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.fms_kuan_adjust model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update fms_kuan_adjust set ");
strSql.Append("date_time=@date_time,");
strSql.Append("customer_id=@customer_id,");
strSql.Append("user_id=@user_id,");
strSql.Append("change_total=@change_total,");
strSql.Append("change_type=@change_type,");
strSql.Append("change_desc=@change_desc,");
strSql.Append("admin_id=@admin_id,");
strSql.Append("erp_dakuanhao=@erp_dakuanhao,");
strSql.Append("erp_time=@erp_time,");
strSql.Append("status=@status");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@date_time", MySqlDbType.Int32, 11),
new MySqlParameter("@customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@change_total", MySqlDbType.Decimal, 10),
new MySqlParameter("@change_type", MySqlDbType.Int16, 2),
new MySqlParameter("@change_desc", MySqlDbType.VarChar, 255),
new MySqlParameter("@admin_id", MySqlDbType.VarChar, 10),
new MySqlParameter("@erp_dakuanhao", MySqlDbType.VarChar, 32),
new MySqlParameter("@erp_time", MySqlDbType.Int32, 11),
new MySqlParameter("@status", MySqlDbType.Int16, 2),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.date_time;
parameters[1].Value = model.customer_id;
parameters[2].Value = model.user_id;
parameters[3].Value = model.change_total;
parameters[4].Value = model.change_type;
parameters[5].Value = model.change_desc;
parameters[6].Value = model.admin_id;
parameters[7].Value = model.erp_dakuanhao;
parameters[8].Value = model.erp_time;
parameters[9].Value = model.status;
parameters[10].Value = model.id;
int rows = FMS_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.fms_kuan_adjust GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,date_time,customer_id,user_id,change_total,change_type,change_desc,admin_id,erp_dakuanhao,erp_time,status,adjust_sn from fms_kuan_adjust ");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = id;
FMS_Model.fms_kuan_adjust model = new FMS_Model.fms_kuan_adjust();
DataSet ds = FMS_DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FMS_Model.fms_kuan_adjust model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into fms_kuan_adjust(");
strSql.Append("id,date_time,customer_id,user_id,change_total,change_type,change_desc,admin_id,erp_dakuanhao,erp_time,debit_account_code,credit_account_code,status,approvalPrimary_empId,approvalPrimary_empcode,approvalPrimary_empname,approvalPrimary_Opinion,approvalPrimary_date,approvalOne_empId,approvalOne_empcode,approvalOne_empname,approvalOne_Opinion,approvalOne_date,approvalTwo_empId,approvalTwo_empcode,approvalTwo_date,approvalTwo_status,adjust_sn)");
strSql.Append(" values (");
strSql.Append("@id,@date_time,@customer_id,@user_id,@change_total,@change_type,@change_desc,@admin_id,@erp_dakuanhao,@erp_time,@debit_account_code,@credit_account_code,@status,@approvalPrimary_empId,@approvalPrimary_empcode,@approvalPrimary_empname,@approvalPrimary_Opinion,@approvalPrimary_date,@approvalOne_empId,@approvalOne_empcode,@approvalOne_empname,@approvalOne_Opinion,@approvalOne_date,@approvalTwo_empId,@approvalTwo_empcode,@approvalTwo_date,@approvalTwo_status,@adjust_sn)");
strSql.Append(";select @@IDENTITY");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11),
new MySqlParameter("@date_time", MySqlDbType.Int32, 11),
new MySqlParameter("@customer_id", MySqlDbType.Int32, 11),
new MySqlParameter("@user_id", MySqlDbType.Int32, 11),
new MySqlParameter("@change_total", MySqlDbType.Decimal, 10),
new MySqlParameter("@change_type", MySqlDbType.Int16, 2),
new MySqlParameter("@change_desc", MySqlDbType.VarChar, 255),
new MySqlParameter("@admin_id", MySqlDbType.VarChar, 10),
new MySqlParameter("@erp_dakuanhao", MySqlDbType.VarChar, 32),
new MySqlParameter("@erp_time", MySqlDbType.Int32, 11),
new MySqlParameter("@debit_account_code", MySqlDbType.VarChar, 100),
new MySqlParameter("@credit_account_code", MySqlDbType.VarChar, 100),
new MySqlParameter("@status", MySqlDbType.Int16, 2),
new MySqlParameter("@approvalPrimary_empId", MySqlDbType.Int32, 11),
new MySqlParameter("@approvalPrimary_empcode", MySqlDbType.VarChar, 60),
new MySqlParameter("@approvalPrimary_empname", MySqlDbType.VarChar, 60),
new MySqlParameter("@approvalPrimary_Opinion", MySqlDbType.VarChar, 200),
new MySqlParameter("@approvalPrimary_date", MySqlDbType.DateTime),
new MySqlParameter("@approvalOne_empId", MySqlDbType.Int32, 11),
new MySqlParameter("@approvalOne_empcode", MySqlDbType.VarChar, 60),
new MySqlParameter("@approvalOne_empname", MySqlDbType.VarChar, 60),
new MySqlParameter("@approvalOne_Opinion", MySqlDbType.VarChar, 200),
new MySqlParameter("@approvalOne_date", MySqlDbType.DateTime),
new MySqlParameter("@approvalTwo_empId", MySqlDbType.Int32, 11),
new MySqlParameter("@approvalTwo_empcode", MySqlDbType.VarChar, 60),
new MySqlParameter("@approvalTwo_date", MySqlDbType.DateTime),
new MySqlParameter("@approvalTwo_status", MySqlDbType.Int16, 2),
new MySqlParameter("@adjust_sn", MySqlDbType.VarChar, 20)
};
parameters[0].Value = model.id;
parameters[1].Value = model.date_time;
parameters[2].Value = model.customer_id;
parameters[3].Value = model.user_id;
parameters[4].Value = model.change_total;
parameters[5].Value = model.change_type;
parameters[6].Value = model.change_desc;
parameters[7].Value = model.admin_id;
parameters[8].Value = model.erp_dakuanhao;
parameters[9].Value = model.erp_time;
parameters[10].Value = model.debit_account_code;
parameters[11].Value = model.credit_account_code;
parameters[12].Value = model.status;
parameters[13].Value = model.approvalPrimary_empId;
parameters[14].Value = model.approvalPrimary_empcode;
parameters[15].Value = model.approvalPrimary_empname;
parameters[16].Value = model.approvalPrimary_Opinion;
parameters[17].Value = model.approvalPrimary_date;
parameters[18].Value = model.approvalOne_empId;
parameters[19].Value = model.approvalOne_empcode;
parameters[20].Value = model.approvalOne_empname;
parameters[21].Value = model.approvalOne_Opinion;
parameters[22].Value = model.approvalOne_date;
parameters[23].Value = model.approvalTwo_empId;
parameters[24].Value = model.approvalTwo_empcode;
parameters[25].Value = model.approvalTwo_date;
parameters[26].Value = model.approvalTwo_status;
parameters[27].Value = model.adjust_sn;
object obj = FMS_DbHelperMySQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
