public static int Insert(SqlTransaction trans, AllocationModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" insert into Sm_Allocation(aid,acode,flowstate,tcodea,tcodeb,isouta,isinb,person,intime,annx,explain,OutAllocationPerson,InAllocationPerson, ");
builder.Append("isouttime,isintime ) ");
builder.Append(" values(@aid,@acode,@flowstate,@tcodea,@tcodeb,@isouta,@isinb,@person,");
builder.Append("@intime,@annx,@explain,@OutAllocationPerson,@InAllocationPerson, ");
builder.Append("@isOutTime,@isInTime) ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@acode", SqlDbType.NVarChar, 0x40), new SqlParameter("@flowstate", SqlDbType.Int), new SqlParameter("@tcodea", SqlDbType.NVarChar, 0x200), new SqlParameter("@tcodeb", SqlDbType.NVarChar, 0x200), new SqlParameter("@isouta", SqlDbType.Bit), new SqlParameter("@isinb", SqlDbType.Bit), new SqlParameter("@person", SqlDbType.NVarChar, 0x40), new SqlParameter("@intime", SqlDbType.VarChar, 0x10), new SqlParameter("@annx", SqlDbType.NVarChar, 0x80), new SqlParameter("@explain", SqlDbType.NVarChar, 0x800), new SqlParameter("@OutAllocationPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InAllocationPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@aid", SqlDbType.NVarChar, 0x40), new SqlParameter("@isOutTime", SqlDbType.NVarChar, 0x40), new SqlParameter("@isInTime", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.Acode;
commandParameters[1].Value = model.FlowState;
commandParameters[2].Value = model.TCodea;
commandParameters[3].Value = model.TCodeb;
commandParameters[4].Value = model.IsOutA;
commandParameters[5].Value = model.IsInB;
commandParameters[6].Value = model.Person;
commandParameters[7].Value = model.InTime;
commandParameters[8].Value = model.Annex;
commandParameters[9].Value = model.Explain;
commandParameters[10].Value = model.OutAllocationPerson;
commandParameters[11].Value = model.InAllocationPerson;
commandParameters[12].Value = model.Aid;
if (!string.IsNullOrEmpty(model.IsOutTime))
{
commandParameters[13].Value = model.IsOutTime;
}
else
{
commandParameters[13].Value = DBNull.Value;
}
if (!string.IsNullOrEmpty(model.IsInTime))
{
commandParameters[14].Value = model.IsInTime;
}
else
{
commandParameters[14].Value = DBNull.Value;
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public static int Update(SqlTransaction trans, AllocationModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update sm_allocation set ");
builder.Append("tcodea=@tcodea,tcodeb=@tcodeb,");
builder.Append("person=@person,intime=@intime,annx=@annx,explain=@explain,");
builder.Append("OutAllocationPerson=@OutAllocationPerson,InAllocationPerson=@InAllocationPerson ");
builder.Append("where acode=@acode ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@tcodea", SqlDbType.NVarChar, 0x200), new SqlParameter("@tcodeb", SqlDbType.NVarChar, 0x200), new SqlParameter("@person", SqlDbType.NVarChar, 0x40), new SqlParameter("@intime", SqlDbType.VarChar, 30), new SqlParameter("@annx", SqlDbType.NVarChar, 0x63), new SqlParameter("@explain", SqlDbType.NVarChar, 0x800), new SqlParameter("@OutAllocationPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@InAllocationPerson", SqlDbType.NVarChar, 0x40), new SqlParameter("@acode", SqlDbType.NVarChar, 0x40) };
commandParameters[0].Value = model.TCodea;
commandParameters[1].Value = model.TCodeb;
commandParameters[2].Value = model.Person;
commandParameters[3].Value = model.InTime;
commandParameters[4].Value = model.Annex;
commandParameters[5].Value = model.Explain;
commandParameters[6].Value = model.OutAllocationPerson;
commandParameters[7].Value = model.InAllocationPerson;
commandParameters[8].Value = model.Acode;
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}