/// <summary>
/// 得到一个对象实体
/// </summary>
public Garfield.Model.CRM_receive GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,Customer_id,Customer_name,Receive_num,Pay_type_id,Pay_type,Receive_amount,Receive_date,C_depid,C_depname,C_empid,C_empname,create_id,create_name,create_date,companyid,order_id,remarks,isDelete,Delete_time from CRM_receive ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Garfield.Model.CRM_receive model = new Garfield.Model.CRM_receive();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["Customer_id"].ToString() != "")
{
model.Customer_id = int.Parse(ds.Tables[0].Rows[0]["Customer_id"].ToString());
}
model.Customer_name = ds.Tables[0].Rows[0]["Customer_name"].ToString();
model.Receive_num = ds.Tables[0].Rows[0]["Receive_num"].ToString();
if (ds.Tables[0].Rows[0]["Pay_type_id"].ToString() != "")
{
model.Pay_type_id = int.Parse(ds.Tables[0].Rows[0]["Pay_type_id"].ToString());
}
model.Pay_type = ds.Tables[0].Rows[0]["Pay_type"].ToString();
if (ds.Tables[0].Rows[0]["Receive_amount"].ToString() != "")
{
model.Receive_amount = decimal.Parse(ds.Tables[0].Rows[0]["Receive_amount"].ToString());
}
if (ds.Tables[0].Rows[0]["Receive_date"].ToString() != "")
{
model.Receive_date = DateTime.Parse(ds.Tables[0].Rows[0]["Receive_date"].ToString());
}
if (ds.Tables[0].Rows[0]["C_depid"].ToString() != "")
{
model.C_depid = int.Parse(ds.Tables[0].Rows[0]["C_depid"].ToString());
}
model.C_depname = ds.Tables[0].Rows[0]["C_depname"].ToString();
if (ds.Tables[0].Rows[0]["C_empid"].ToString() != "")
{
model.C_empid = int.Parse(ds.Tables[0].Rows[0]["C_empid"].ToString());
}
model.C_empname = ds.Tables[0].Rows[0]["C_empname"].ToString();
if (ds.Tables[0].Rows[0]["create_id"].ToString() != "")
{
model.create_id = int.Parse(ds.Tables[0].Rows[0]["create_id"].ToString());
}
model.create_name = ds.Tables[0].Rows[0]["create_name"].ToString();
if (ds.Tables[0].Rows[0]["create_date"].ToString() != "")
{
model.create_date = DateTime.Parse(ds.Tables[0].Rows[0]["create_date"].ToString());
}
if (ds.Tables[0].Rows[0]["companyid"].ToString() != "")
{
model.companyid = int.Parse(ds.Tables[0].Rows[0]["companyid"].ToString());
}
if (ds.Tables[0].Rows[0]["order_id"].ToString() != "")
{
model.order_id = int.Parse(ds.Tables[0].Rows[0]["order_id"].ToString());
}
model.remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
if (ds.Tables[0].Rows[0]["isDelete"].ToString() != "")
{
model.isDelete = int.Parse(ds.Tables[0].Rows[0]["isDelete"].ToString());
}
if (ds.Tables[0].Rows[0]["Delete_time"].ToString() != "")
{
model.Delete_time = DateTime.Parse(ds.Tables[0].Rows[0]["Delete_time"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Garfield.Model.CRM_receive model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CRM_receive(");
strSql.Append("Customer_id,Customer_name,Receive_num,Pay_type_id,Pay_type,Receive_amount,Receive_date,C_depid,C_depname,C_empid,C_empname,create_id,create_name,create_date,companyid,order_id,remarks,isDelete,Delete_time,receive_direction_id,receive_direction_name,Receive_real)");
strSql.Append(" values (");
strSql.Append("@Customer_id,@Customer_name,@Receive_num,@Pay_type_id,@Pay_type,@Receive_amount,@Receive_date,@C_depid,@C_depname,@C_empid,@C_empname,@create_id,@create_name,@create_date,@companyid,@order_id,@remarks,@isDelete,@Delete_time,@receive_direction_id,@receive_direction_name,@Receive_real)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Customer_id", SqlDbType.Int, 4),
new SqlParameter("@Customer_name", SqlDbType.VarChar, 250),
new SqlParameter("@Receive_num", SqlDbType.VarChar, 250),
new SqlParameter("@Pay_type_id", SqlDbType.Int, 4),
new SqlParameter("@Pay_type", SqlDbType.VarChar, 250),
new SqlParameter("@Receive_amount", SqlDbType.Float, 8),
new SqlParameter("@Receive_date", SqlDbType.DateTime),
new SqlParameter("@C_depid", SqlDbType.Int, 4),
new SqlParameter("@C_depname", SqlDbType.VarChar, 250),
new SqlParameter("@C_empid", SqlDbType.Int, 4),
new SqlParameter("@C_empname", SqlDbType.VarChar, 250),
new SqlParameter("@create_id", SqlDbType.Int, 4),
new SqlParameter("@create_name", SqlDbType.VarChar, 250),
new SqlParameter("@create_date", SqlDbType.DateTime),
new SqlParameter("@companyid", SqlDbType.Int, 4),
new SqlParameter("@order_id", SqlDbType.Int, 4),
new SqlParameter("@remarks", SqlDbType.VarChar, -1),
new SqlParameter("@isDelete", SqlDbType.Int, 4),
new SqlParameter("@Delete_time", SqlDbType.DateTime),
new SqlParameter("@receive_direction_id", SqlDbType.Int, 4),
new SqlParameter("@receive_direction_name", SqlDbType.VarChar, 250),
new SqlParameter("@Receive_real", SqlDbType.Float, 8)
};
parameters[0].Value = model.Customer_id;
parameters[1].Value = model.Customer_name;
parameters[2].Value = model.Receive_num;
parameters[3].Value = model.Pay_type_id;
parameters[4].Value = model.Pay_type;
parameters[5].Value = model.Receive_amount;
parameters[6].Value = model.Receive_date;
parameters[7].Value = model.C_depid;
parameters[8].Value = model.C_depname;
parameters[9].Value = model.C_empid;
parameters[10].Value = model.C_empname;
parameters[11].Value = model.create_id;
parameters[12].Value = model.create_name;
parameters[13].Value = model.create_date;
parameters[14].Value = model.companyid;
parameters[15].Value = model.order_id;
parameters[16].Value = model.remarks;
parameters[17].Value = model.isDelete;
parameters[18].Value = model.Delete_time;
parameters[19].Value = model.receive_direction_id;
parameters[20].Value = model.receive_direction_name;
parameters[21].Value = model.receive_real;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Garfield.Model.CRM_receive model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CRM_receive set ");
strSql.Append("Customer_id=@Customer_id,");
strSql.Append("Customer_name=@Customer_name,");
strSql.Append("Receive_num=@Receive_num,");
strSql.Append("Pay_type_id=@Pay_type_id,");
strSql.Append("Pay_type=@Pay_type,");
strSql.Append("Receive_amount=@Receive_amount,");
strSql.Append("Receive_date=@Receive_date,");
strSql.Append("C_depid=@C_depid,");
strSql.Append("C_depname=@C_depname,");
strSql.Append("C_empid=@C_empid,");
strSql.Append("C_empname=@C_empname,");
strSql.Append("companyid=@companyid,");
strSql.Append("order_id=@order_id,");
strSql.Append("remarks=@remarks,");
strSql.Append("receive_direction_id=@receive_direction_id,");
strSql.Append("receive_direction_name=@receive_direction_name,");
strSql.Append("Receive_real=@Receive_real");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@Customer_id", SqlDbType.Int, 4),
new SqlParameter("@Customer_name", SqlDbType.VarChar, 250),
new SqlParameter("@Receive_num", SqlDbType.VarChar, 250),
new SqlParameter("@Pay_type_id", SqlDbType.Int, 4),
new SqlParameter("@Pay_type", SqlDbType.VarChar, 250),
new SqlParameter("@Receive_amount", SqlDbType.Float, 8),
new SqlParameter("@Receive_date", SqlDbType.DateTime),
new SqlParameter("@C_depid", SqlDbType.Int, 4),
new SqlParameter("@C_depname", SqlDbType.VarChar, 250),
new SqlParameter("@C_empid", SqlDbType.Int, 4),
new SqlParameter("@C_empname", SqlDbType.VarChar, 250),
new SqlParameter("@companyid", SqlDbType.Int, 4),
new SqlParameter("@order_id", SqlDbType.Int, 4),
new SqlParameter("@remarks", SqlDbType.VarChar, -1),
new SqlParameter("@receive_direction_id", SqlDbType.Int, 4),
new SqlParameter("@receive_direction_name", SqlDbType.VarChar, 250),
new SqlParameter("@Receive_real", SqlDbType.Float, 8),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.Customer_id;
parameters[1].Value = model.Customer_name;
parameters[2].Value = model.Receive_num;
parameters[3].Value = model.Pay_type_id;
parameters[4].Value = model.Pay_type;
parameters[5].Value = model.Receive_amount;
parameters[6].Value = model.Receive_date;
parameters[7].Value = model.C_depid;
parameters[8].Value = model.C_depname;
parameters[9].Value = model.C_empid;
parameters[10].Value = model.C_empname;
parameters[11].Value = model.companyid;
parameters[12].Value = model.order_id;
parameters[13].Value = model.remarks;
parameters[14].Value = model.receive_direction_id;
parameters[15].Value = model.receive_direction_name;
parameters[16].Value = model.receive_real;
parameters[17].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}