/// <summary>
/// 得到一个对象实体
/// </summary>
public Hownet.Model.CW_KJFL GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,编号,年,月,日,时间,附件,制单人,审核,记帐,财务主管,制单人ID,审核ID,记帐ID,财务主管ID,制单日期,审核日期,记账日期,主管审核日期,帐户,帐户ID,TypeID,TableID from CW_KJFL ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Hownet.Model.CW_KJFL model = new Hownet.Model.CW_KJFL();
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());
}
model.编号 = ds.Tables[0].Rows[0]["编号"].ToString();
model.年 = ds.Tables[0].Rows[0]["年"].ToString();
model.月 = ds.Tables[0].Rows[0]["月"].ToString();
model.日 = ds.Tables[0].Rows[0]["日"].ToString();
model.时间 = ds.Tables[0].Rows[0]["时间"].ToString();
model.附件 = ds.Tables[0].Rows[0]["附件"].ToString();
model.制单人 = ds.Tables[0].Rows[0]["制单人"].ToString();
model.审核 = 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());
}
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]["记帐ID"] != null && ds.Tables[0].Rows[0]["记帐ID"].ToString() != "")
{
model.记帐ID = int.Parse(ds.Tables[0].Rows[0]["记帐ID"].ToString());
}
model.财务主管ID = ds.Tables[0].Rows[0]["财务主管ID"].ToString();
model.制单日期 = ds.Tables[0].Rows[0]["制单日期"].ToString();
model.审核日期 = ds.Tables[0].Rows[0]["审核日期"].ToString();
model.记账日期 = 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());
}
if (ds.Tables[0].Rows[0]["TypeID"] != null && ds.Tables[0].Rows[0]["TypeID"].ToString() != "")
{
model.TypeID = int.Parse(ds.Tables[0].Rows[0]["TypeID"].ToString());
}
if (ds.Tables[0].Rows[0]["TableID"] != null && ds.Tables[0].Rows[0]["TableID"].ToString() != "")
{
model.TableID = int.Parse(ds.Tables[0].Rows[0]["TableID"].ToString());
}
model.A = 1;
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.CW_KJFL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CW_KJFL(");
strSql.Append("编号,年,月,日,时间,附件,制单人,审核,记帐,财务主管,制单人ID,审核ID,记帐ID,财务主管ID,制单日期,审核日期,记账日期,主管审核日期,帐户,帐户ID,TypeID,TableID)");
strSql.Append(" values (");
strSql.Append("@编号,@年,@月,@日,@时间,@附件,@制单人,@审核,@记帐,@财务主管,@制单人ID,@审核ID,@记帐ID,@财务主管ID,@制单日期,@审核日期,@记账日期,@主管审核日期,@帐户,@帐户ID,@TypeID,@TableID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@编号", SqlDbType.NVarChar, 50),
new SqlParameter("@年", SqlDbType.NChar, 4),
new SqlParameter("@月", SqlDbType.NChar, 2),
new SqlParameter("@日", SqlDbType.NChar, 2),
new SqlParameter("@时间", SqlDbType.NChar, 10),
new SqlParameter("@附件", SqlDbType.NVarChar, 50),
new SqlParameter("@制单人", SqlDbType.NVarChar, 50),
new SqlParameter("@审核", SqlDbType.NVarChar, 50),
new SqlParameter("@记帐", SqlDbType.NVarChar, 50),
new SqlParameter("@财务主管", SqlDbType.NVarChar, 50),
new SqlParameter("@制单人ID", SqlDbType.Int, 4),
new SqlParameter("@审核ID", SqlDbType.Int, 4),
new SqlParameter("@记帐ID", SqlDbType.Int, 4),
new SqlParameter("@财务主管ID", SqlDbType.NVarChar, 50),
new SqlParameter("@制单日期", SqlDbType.NVarChar, 50),
new SqlParameter("@审核日期", SqlDbType.NVarChar, 50),
new SqlParameter("@记账日期", SqlDbType.NVarChar, 50),
new SqlParameter("@主管审核日期", SqlDbType.NVarChar, 50),
new SqlParameter("@帐户", SqlDbType.NVarChar, 50),
new SqlParameter("@帐户ID", SqlDbType.Int, 4),
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@TableID", SqlDbType.Int, 4)
};
parameters[0].Value = model.编号;
parameters[1].Value = model.年;
parameters[2].Value = model.月;
parameters[3].Value = model.日;
parameters[4].Value = model.时间;
parameters[5].Value = model.附件;
parameters[6].Value = model.制单人;
parameters[7].Value = model.审核;
parameters[8].Value = model.记帐;
parameters[9].Value = model.财务主管;
parameters[10].Value = model.制单人ID;
parameters[11].Value = model.审核ID;
parameters[12].Value = model.记帐ID;
parameters[13].Value = model.财务主管ID;
parameters[14].Value = model.制单日期;
parameters[15].Value = model.审核日期;
parameters[16].Value = model.记账日期;
parameters[17].Value = model.主管审核日期;
parameters[18].Value = model.帐户;
parameters[19].Value = model.帐户ID;
parameters[20].Value = model.TypeID;
parameters[21].Value = model.TableID;
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_KJFL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CW_KJFL set ");
strSql.Append("编号=@编号,");
strSql.Append("年=@年,");
strSql.Append("月=@月,");
strSql.Append("日=@日,");
strSql.Append("时间=@时间,");
strSql.Append("附件=@附件,");
strSql.Append("制单人=@制单人,");
strSql.Append("审核=@审核,");
strSql.Append("记帐=@记帐,");
strSql.Append("财务主管=@财务主管,");
strSql.Append("制单人ID=@制单人ID,");
strSql.Append("审核ID=@审核ID,");
strSql.Append("记帐ID=@记帐ID,");
strSql.Append("财务主管ID=@财务主管ID,");
strSql.Append("制单日期=@制单日期,");
strSql.Append("审核日期=@审核日期,");
strSql.Append("记账日期=@记账日期,");
strSql.Append("主管审核日期=@主管审核日期,");
strSql.Append("帐户=@帐户,");
strSql.Append("帐户ID=@帐户ID,");
strSql.Append("TypeID=@TypeID,");
strSql.Append("TableID=@TableID");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@编号", SqlDbType.NVarChar, 50),
new SqlParameter("@年", SqlDbType.NChar, 4),
new SqlParameter("@月", SqlDbType.NChar, 2),
new SqlParameter("@日", SqlDbType.NChar, 2),
new SqlParameter("@时间", SqlDbType.NChar, 10),
new SqlParameter("@附件", SqlDbType.NVarChar, 50),
new SqlParameter("@制单人", SqlDbType.NVarChar, 50),
new SqlParameter("@审核", SqlDbType.NVarChar, 50),
new SqlParameter("@记帐", SqlDbType.NVarChar, 50),
new SqlParameter("@财务主管", SqlDbType.NVarChar, 50),
new SqlParameter("@制单人ID", SqlDbType.Int, 4),
new SqlParameter("@审核ID", SqlDbType.Int, 4),
new SqlParameter("@记帐ID", SqlDbType.Int, 4),
new SqlParameter("@财务主管ID", SqlDbType.NVarChar, 50),
new SqlParameter("@制单日期", SqlDbType.NVarChar, 50),
new SqlParameter("@审核日期", SqlDbType.NVarChar, 50),
new SqlParameter("@记账日期", SqlDbType.NVarChar, 50),
new SqlParameter("@主管审核日期", SqlDbType.NVarChar, 50),
new SqlParameter("@帐户", SqlDbType.NVarChar, 50),
new SqlParameter("@帐户ID", SqlDbType.Int, 4),
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@TableID", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.编号;
parameters[1].Value = model.年;
parameters[2].Value = model.月;
parameters[3].Value = model.日;
parameters[4].Value = model.时间;
parameters[5].Value = model.附件;
parameters[6].Value = model.制单人;
parameters[7].Value = model.审核;
parameters[8].Value = model.记帐;
parameters[9].Value = model.财务主管;
parameters[10].Value = model.制单人ID;
parameters[11].Value = model.审核ID;
parameters[12].Value = model.记帐ID;
parameters[13].Value = model.财务主管ID;
parameters[14].Value = model.制单日期;
parameters[15].Value = model.审核日期;
parameters[16].Value = model.记账日期;
parameters[17].Value = model.主管审核日期;
parameters[18].Value = model.帐户;
parameters[19].Value = model.帐户ID;
parameters[20].Value = model.TypeID;
parameters[21].Value = model.TableID;
parameters[22].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}