/// <summary>
/// 得到一个对象实体
/// </summary>
public Hownet.Model.CW_KJFLInfo GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MainID,项目名称,项目名称ID,款号,款号ID,客户订单编号,客户订单ID,客户,客户ID,费用类别,费用类别ID,金额,手续费,备注,报销人,报销人ID,二级科目,二级科目ID,报销部门,报销部门ID from CW_KJFLInfo ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Hownet.Model.CW_KJFLInfo model = new Hownet.Model.CW_KJFLInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["MainID"] != null && ds.Tables[0].Rows[0]["MainID"].ToString() != "")
{
model.MainID = int.Parse(ds.Tables[0].Rows[0]["MainID"].ToString());
}
model.项目名称 = ds.Tables[0].Rows[0]["项目名称"].ToString();
if (ds.Tables[0].Rows[0]["项目名称ID"] != null && ds.Tables[0].Rows[0]["项目名称ID"].ToString() != "")
{
model.项目名称ID = int.Parse(ds.Tables[0].Rows[0]["项目名称ID"].ToString());
}
model.款号 = ds.Tables[0].Rows[0]["款号"].ToString();
if (ds.Tables[0].Rows[0]["款号ID"] != null && ds.Tables[0].Rows[0]["款号ID"].ToString() != "")
{
model.款号ID = int.Parse(ds.Tables[0].Rows[0]["款号ID"].ToString());
}
model.客户订单编号 = ds.Tables[0].Rows[0]["客户订单编号"].ToString();
if (ds.Tables[0].Rows[0]["客户订单ID"] != null && ds.Tables[0].Rows[0]["客户订单ID"].ToString() != "")
{
model.客户订单ID = int.Parse(ds.Tables[0].Rows[0]["客户订单ID"].ToString());
}
model.客户 = ds.Tables[0].Rows[0]["客户"].ToString();
if (ds.Tables[0].Rows[0]["客户ID"] != null && ds.Tables[0].Rows[0]["客户ID"].ToString() != "")
{
model.客户ID = int.Parse(ds.Tables[0].Rows[0]["客户ID"].ToString());
}
model.费用类别 = ds.Tables[0].Rows[0]["费用类别"].ToString();
if (ds.Tables[0].Rows[0]["费用类别ID"] != null && ds.Tables[0].Rows[0]["费用类别ID"].ToString() != "")
{
model.费用类别ID = int.Parse(ds.Tables[0].Rows[0]["费用类别ID"].ToString());
}
if (ds.Tables[0].Rows[0]["金额"] != null && ds.Tables[0].Rows[0]["金额"].ToString() != "")
{
model.金额 = decimal.Parse(ds.Tables[0].Rows[0]["金额"].ToString());
}
if (ds.Tables[0].Rows[0]["手续费"] != null && ds.Tables[0].Rows[0]["手续费"].ToString() != "")
{
model.手续费 = decimal.Parse(ds.Tables[0].Rows[0]["手续费"].ToString());
}
model.备注 = ds.Tables[0].Rows[0]["备注"].ToString();
model.报销人 = ds.Tables[0].Rows[0]["报销人"].ToString();
if (ds.Tables[0].Rows[0]["报销人ID"] != null && ds.Tables[0].Rows[0]["报销人ID"].ToString() != "")
{
model.报销人ID = int.Parse(ds.Tables[0].Rows[0]["报销人ID"].ToString());
}
model.二级科目 = ds.Tables[0].Rows[0]["二级科目"].ToString();
if (ds.Tables[0].Rows[0]["二级科目ID"] != null && ds.Tables[0].Rows[0]["二级科目ID"].ToString() != "")
{
model.二级科目ID = int.Parse(ds.Tables[0].Rows[0]["二级科目ID"].ToString());
}
model.报销部门 = ds.Tables[0].Rows[0]["报销部门"].ToString();
if (ds.Tables[0].Rows[0]["报销部门ID"] != null && ds.Tables[0].Rows[0]["报销部门ID"].ToString() != "")
{
model.报销部门ID = int.Parse(ds.Tables[0].Rows[0]["报销部门ID"].ToString());
}
model.A = 1;
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.CW_KJFLInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CW_KJFLInfo(");
strSql.Append("MainID,项目名称,项目名称ID,款号,款号ID,客户订单编号,客户订单ID,客户,客户ID,费用类别,费用类别ID,金额,手续费,备注,报销人,报销人ID,二级科目,二级科目ID,报销部门,报销部门ID)");
strSql.Append(" values (");
strSql.Append("@MainID,@项目名称,@项目名称ID,@款号,@款号ID,@客户订单编号,@客户订单ID,@客户,@客户ID,@费用类别,@费用类别ID,@金额,@手续费,@备注,@报销人,@报销人ID,@二级科目,@二级科目ID,@报销部门,@报销部门ID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MainID", SqlDbType.Int, 4),
new SqlParameter("@项目名称", SqlDbType.NVarChar, 50),
new SqlParameter("@项目名称ID", SqlDbType.Int, 4),
new SqlParameter("@款号", SqlDbType.NVarChar, 50),
new SqlParameter("@款号ID", SqlDbType.Int, 4),
new SqlParameter("@客户订单编号", SqlDbType.NVarChar, 50),
new SqlParameter("@客户订单ID", SqlDbType.Int, 4),
new SqlParameter("@客户", SqlDbType.NVarChar, 50),
new SqlParameter("@客户ID", SqlDbType.Int, 4),
new SqlParameter("@费用类别", SqlDbType.NVarChar, 50),
new SqlParameter("@费用类别ID", SqlDbType.Int, 4),
new SqlParameter("@金额", SqlDbType.Decimal, 9),
new SqlParameter("@手续费", SqlDbType.Decimal, 9),
new SqlParameter("@备注", SqlDbType.NVarChar, 2000),
new SqlParameter("@报销人", SqlDbType.NVarChar, 50),
new SqlParameter("@报销人ID", SqlDbType.Int, 4),
new SqlParameter("@二级科目", SqlDbType.NVarChar, 50),
new SqlParameter("@二级科目ID", SqlDbType.Int, 4),
new SqlParameter("@报销部门", SqlDbType.NVarChar, 50),
new SqlParameter("@报销部门ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.MainID;
parameters[1].Value = model.项目名称;
parameters[2].Value = model.项目名称ID;
parameters[3].Value = model.款号;
parameters[4].Value = model.款号ID;
parameters[5].Value = model.客户订单编号;
parameters[6].Value = model.客户订单ID;
parameters[7].Value = model.客户;
parameters[8].Value = model.客户ID;
parameters[9].Value = model.费用类别;
parameters[10].Value = model.费用类别ID;
parameters[11].Value = model.金额;
parameters[12].Value = model.手续费;
parameters[13].Value = model.备注;
parameters[14].Value = model.报销人;
parameters[15].Value = model.报销人ID;
parameters[16].Value = model.二级科目;
parameters[17].Value = model.二级科目ID;
parameters[18].Value = model.报销部门;
parameters[19].Value = model.报销部门ID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hownet.Model.CW_KJFLInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CW_KJFLInfo set ");
strSql.Append("MainID=@MainID,");
strSql.Append("项目名称=@项目名称,");
strSql.Append("项目名称ID=@项目名称ID,");
strSql.Append("款号=@款号,");
strSql.Append("款号ID=@款号ID,");
strSql.Append("客户订单编号=@客户订单编号,");
strSql.Append("客户订单ID=@客户订单ID,");
strSql.Append("客户=@客户,");
strSql.Append("客户ID=@客户ID,");
strSql.Append("费用类别=@费用类别,");
strSql.Append("费用类别ID=@费用类别ID,");
strSql.Append("金额=@金额,");
strSql.Append("手续费=@手续费,");
strSql.Append("备注=@备注,");
strSql.Append("报销人=@报销人,");
strSql.Append("报销人ID=@报销人ID,");
strSql.Append("二级科目=@二级科目,");
strSql.Append("二级科目ID=@二级科目ID,");
strSql.Append("报销部门=@报销部门,");
strSql.Append("报销部门ID=@报销部门ID");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@MainID", SqlDbType.Int, 4),
new SqlParameter("@项目名称", SqlDbType.NVarChar, 50),
new SqlParameter("@项目名称ID", SqlDbType.Int, 4),
new SqlParameter("@款号", SqlDbType.NVarChar, 50),
new SqlParameter("@款号ID", SqlDbType.Int, 4),
new SqlParameter("@客户订单编号", SqlDbType.NVarChar, 50),
new SqlParameter("@客户订单ID", SqlDbType.Int, 4),
new SqlParameter("@客户", SqlDbType.NVarChar, 50),
new SqlParameter("@客户ID", SqlDbType.Int, 4),
new SqlParameter("@费用类别", SqlDbType.NVarChar, 50),
new SqlParameter("@费用类别ID", SqlDbType.Int, 4),
new SqlParameter("@金额", SqlDbType.Decimal, 9),
new SqlParameter("@手续费", SqlDbType.Decimal, 9),
new SqlParameter("@备注", SqlDbType.NVarChar, 2000),
new SqlParameter("@报销人", SqlDbType.NVarChar, 50),
new SqlParameter("@报销人ID", SqlDbType.Int, 4),
new SqlParameter("@二级科目", SqlDbType.NVarChar, 50),
new SqlParameter("@二级科目ID", SqlDbType.Int, 4),
new SqlParameter("@报销部门", SqlDbType.NVarChar, 50),
new SqlParameter("@报销部门ID", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.MainID;
parameters[1].Value = model.项目名称;
parameters[2].Value = model.项目名称ID;
parameters[3].Value = model.款号;
parameters[4].Value = model.款号ID;
parameters[5].Value = model.客户订单编号;
parameters[6].Value = model.客户订单ID;
parameters[7].Value = model.客户;
parameters[8].Value = model.客户ID;
parameters[9].Value = model.费用类别;
parameters[10].Value = model.费用类别ID;
parameters[11].Value = model.金额;
parameters[12].Value = model.手续费;
parameters[13].Value = model.备注;
parameters[14].Value = model.报销人;
parameters[15].Value = model.报销人ID;
parameters[16].Value = model.二级科目;
parameters[17].Value = model.二级科目ID;
parameters[18].Value = model.报销部门;
parameters[19].Value = model.报销部门ID;
parameters[20].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
