/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WMS_Database.View_PlanMainModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into View_PlanMain(");
strSql.Append("Plan_Type_ID,Plan_ID,Plan_Serial_Num,Plan_Code,Plan_Create_Time,Plan_Begin_Time,Plan_End_Time,Plan_Bill_Time,Plan_Status,Plan_Operater,Plan_From_Dept,Plan_To_Dept,Plan_From_User,Plan_To_User,Plan_Import_Flag,Plan_Remark,Plan_Type_Code,Plan_Type_Name,Plan_Type_Group,Plan_Type_Remark,Plan_Type_InOut,Plan_Type_Order,Plan_Type_Flag)");
strSql.Append(" values (");
strSql.Append("@Plan_Type_ID,@Plan_ID,@Plan_Serial_Num,@Plan_Code,@Plan_Create_Time,@Plan_Begin_Time,@Plan_End_Time,@Plan_Bill_Time,@Plan_Status,@Plan_Operater,@Plan_From_Dept,@Plan_To_Dept,@Plan_From_User,@Plan_To_User,@Plan_Import_Flag,@Plan_Remark,@Plan_Type_Code,@Plan_Type_Name,@Plan_Type_Group,@Plan_Type_Remark,@Plan_Type_InOut,@Plan_Type_Order,@Plan_Type_Flag)");
SqlParameter[] parameters =
{
new SqlParameter("@Plan_Type_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Serial_Num", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Create_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Begin_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_End_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Bill_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Operater", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_From_Dept", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_To_Dept", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_From_User", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_To_User", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Import_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Group", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Order", SqlDbType.Int, 4),
new SqlParameter("@Plan_Type_Flag", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Plan_Type_ID;
parameters[1].Value = model.Plan_ID;
parameters[2].Value = model.Plan_Serial_Num;
parameters[3].Value = model.Plan_Code;
parameters[4].Value = model.Plan_Create_Time;
parameters[5].Value = model.Plan_Begin_Time;
parameters[6].Value = model.Plan_End_Time;
parameters[7].Value = model.Plan_Bill_Time;
parameters[8].Value = model.Plan_Status;
parameters[9].Value = model.Plan_Operater;
parameters[10].Value = model.Plan_From_Dept;
parameters[11].Value = model.Plan_To_Dept;
parameters[12].Value = model.Plan_From_User;
parameters[13].Value = model.Plan_To_User;
parameters[14].Value = model.Plan_Import_Flag;
parameters[15].Value = model.Plan_Remark;
parameters[16].Value = model.Plan_Type_Code;
parameters[17].Value = model.Plan_Type_Name;
parameters[18].Value = model.Plan_Type_Group;
parameters[19].Value = model.Plan_Type_Remark;
parameters[20].Value = model.Plan_Type_InOut;
parameters[21].Value = model.Plan_Type_Order;
parameters[22].Value = model.Plan_Type_Flag;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WMS_Database.View_PlanMainModel DataRowToModel(DataRow row)
{
WMS_Database.View_PlanMainModel model = new WMS_Database.View_PlanMainModel();
if (row != null)
{
if (row["Plan_Type_ID"] != null)
{
model.Plan_Type_ID = row["Plan_Type_ID"].ToString();
}
if (row["Plan_ID"] != null)
{
model.Plan_ID = row["Plan_ID"].ToString();
}
if (row["Plan_Serial_Num"] != null)
{
model.Plan_Serial_Num = row["Plan_Serial_Num"].ToString();
}
if (row["Plan_Code"] != null)
{
model.Plan_Code = row["Plan_Code"].ToString();
}
if (row["Plan_Create_Time"] != null && row["Plan_Create_Time"].ToString() != "")
{
model.Plan_Create_Time = DateTime.Parse(row["Plan_Create_Time"].ToString());
}
if (row["Plan_Begin_Time"] != null && row["Plan_Begin_Time"].ToString() != "")
{
model.Plan_Begin_Time = DateTime.Parse(row["Plan_Begin_Time"].ToString());
}
if (row["Plan_End_Time"] != null && row["Plan_End_Time"].ToString() != "")
{
model.Plan_End_Time = DateTime.Parse(row["Plan_End_Time"].ToString());
}
if (row["Plan_Bill_Time"] != null && row["Plan_Bill_Time"].ToString() != "")
{
model.Plan_Bill_Time = DateTime.Parse(row["Plan_Bill_Time"].ToString());
}
if (row["Plan_Status"] != null)
{
model.Plan_Status = row["Plan_Status"].ToString();
}
if (row["Plan_Operater"] != null)
{
model.Plan_Operater = row["Plan_Operater"].ToString();
}
if (row["Plan_From_Dept"] != null)
{
model.Plan_From_Dept = row["Plan_From_Dept"].ToString();
}
if (row["Plan_To_Dept"] != null)
{
model.Plan_To_Dept = row["Plan_To_Dept"].ToString();
}
if (row["Plan_From_User"] != null)
{
model.Plan_From_User = row["Plan_From_User"].ToString();
}
if (row["Plan_To_User"] != null)
{
model.Plan_To_User = row["Plan_To_User"].ToString();
}
if (row["Plan_Import_Flag"] != null)
{
model.Plan_Import_Flag = row["Plan_Import_Flag"].ToString();
}
if (row["Plan_Remark"] != null)
{
model.Plan_Remark = row["Plan_Remark"].ToString();
}
if (row["Plan_Type_Code"] != null)
{
model.Plan_Type_Code = row["Plan_Type_Code"].ToString();
}
if (row["Plan_Type_Name"] != null)
{
model.Plan_Type_Name = row["Plan_Type_Name"].ToString();
}
if (row["Plan_Type_Group"] != null)
{
model.Plan_Type_Group = row["Plan_Type_Group"].ToString();
}
if (row["Plan_Type_Remark"] != null)
{
model.Plan_Type_Remark = row["Plan_Type_Remark"].ToString();
}
if (row["Plan_Type_InOut"] != null)
{
model.Plan_Type_InOut = row["Plan_Type_InOut"].ToString();
}
if (row["Plan_Type_Order"] != null && row["Plan_Type_Order"].ToString() != "")
{
model.Plan_Type_Order = int.Parse(row["Plan_Type_Order"].ToString());
}
if (row["Plan_Type_Flag"] != null)
{
model.Plan_Type_Flag = row["Plan_Type_Flag"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WMS_Database.View_PlanMainModel GetModel(string Plan_Type_ID, string Plan_ID, string Plan_Serial_Num, string Plan_Code, DateTime Plan_Create_Time, DateTime Plan_Begin_Time, DateTime Plan_End_Time, DateTime Plan_Bill_Time, string Plan_Status, string Plan_Operater, string Plan_From_Dept, string Plan_To_Dept, string Plan_From_User, string Plan_To_User, string Plan_Import_Flag, string Plan_Remark, string Plan_Type_Code, string Plan_Type_Name, string Plan_Type_Group, string Plan_Type_Remark, string Plan_Type_InOut, int Plan_Type_Order, string Plan_Type_Flag)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Plan_Type_ID,Plan_ID,Plan_Serial_Num,Plan_Code,Plan_Create_Time,Plan_Begin_Time,Plan_End_Time,Plan_Bill_Time,Plan_Status,Plan_Operater,Plan_From_Dept,Plan_To_Dept,Plan_From_User,Plan_To_User,Plan_Import_Flag,Plan_Remark,Plan_Type_Code,Plan_Type_Name,Plan_Type_Group,Plan_Type_Remark,Plan_Type_InOut,Plan_Type_Order,Plan_Type_Flag from View_PlanMain ");
strSql.Append(" where Plan_Type_ID=@Plan_Type_ID and Plan_ID=@Plan_ID and Plan_Serial_Num=@Plan_Serial_Num and Plan_Code=@Plan_Code and Plan_Create_Time=@Plan_Create_Time and Plan_Begin_Time=@Plan_Begin_Time and Plan_End_Time=@Plan_End_Time and Plan_Bill_Time=@Plan_Bill_Time and Plan_Status=@Plan_Status and Plan_Operater=@Plan_Operater and Plan_From_Dept=@Plan_From_Dept and Plan_To_Dept=@Plan_To_Dept and Plan_From_User=@Plan_From_User and Plan_To_User=@Plan_To_User and Plan_Import_Flag=@Plan_Import_Flag and Plan_Remark=@Plan_Remark and Plan_Type_Code=@Plan_Type_Code and Plan_Type_Name=@Plan_Type_Name and Plan_Type_Group=@Plan_Type_Group and Plan_Type_Remark=@Plan_Type_Remark and Plan_Type_InOut=@Plan_Type_InOut and Plan_Type_Order=@Plan_Type_Order and Plan_Type_Flag=@Plan_Type_Flag ");
SqlParameter[] parameters =
{
new SqlParameter("@Plan_Type_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Serial_Num", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Create_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Begin_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_End_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Bill_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Operater", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_From_Dept", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_To_Dept", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_From_User", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_To_User", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Import_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Group", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Order", SqlDbType.Int, 4),
new SqlParameter("@Plan_Type_Flag", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Plan_Type_ID;
parameters[1].Value = Plan_ID;
parameters[2].Value = Plan_Serial_Num;
parameters[3].Value = Plan_Code;
parameters[4].Value = Plan_Create_Time;
parameters[5].Value = Plan_Begin_Time;
parameters[6].Value = Plan_End_Time;
parameters[7].Value = Plan_Bill_Time;
parameters[8].Value = Plan_Status;
parameters[9].Value = Plan_Operater;
parameters[10].Value = Plan_From_Dept;
parameters[11].Value = Plan_To_Dept;
parameters[12].Value = Plan_From_User;
parameters[13].Value = Plan_To_User;
parameters[14].Value = Plan_Import_Flag;
parameters[15].Value = Plan_Remark;
parameters[16].Value = Plan_Type_Code;
parameters[17].Value = Plan_Type_Name;
parameters[18].Value = Plan_Type_Group;
parameters[19].Value = Plan_Type_Remark;
parameters[20].Value = Plan_Type_InOut;
parameters[21].Value = Plan_Type_Order;
parameters[22].Value = Plan_Type_Flag;
WMS_Database.View_PlanMainModel model = new WMS_Database.View_PlanMainModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WMS_Database.View_PlanMainModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update View_PlanMain set ");
strSql.Append("Plan_Type_ID=@Plan_Type_ID,");
strSql.Append("Plan_ID=@Plan_ID,");
strSql.Append("Plan_Serial_Num=@Plan_Serial_Num,");
strSql.Append("Plan_Code=@Plan_Code,");
strSql.Append("Plan_Create_Time=@Plan_Create_Time,");
strSql.Append("Plan_Begin_Time=@Plan_Begin_Time,");
strSql.Append("Plan_End_Time=@Plan_End_Time,");
strSql.Append("Plan_Bill_Time=@Plan_Bill_Time,");
strSql.Append("Plan_Status=@Plan_Status,");
strSql.Append("Plan_Operater=@Plan_Operater,");
strSql.Append("Plan_From_Dept=@Plan_From_Dept,");
strSql.Append("Plan_To_Dept=@Plan_To_Dept,");
strSql.Append("Plan_From_User=@Plan_From_User,");
strSql.Append("Plan_To_User=@Plan_To_User,");
strSql.Append("Plan_Import_Flag=@Plan_Import_Flag,");
strSql.Append("Plan_Remark=@Plan_Remark,");
strSql.Append("Plan_Type_Code=@Plan_Type_Code,");
strSql.Append("Plan_Type_Name=@Plan_Type_Name,");
strSql.Append("Plan_Type_Group=@Plan_Type_Group,");
strSql.Append("Plan_Type_Remark=@Plan_Type_Remark,");
strSql.Append("Plan_Type_InOut=@Plan_Type_InOut,");
strSql.Append("Plan_Type_Order=@Plan_Type_Order,");
strSql.Append("Plan_Type_Flag=@Plan_Type_Flag");
strSql.Append(" where Plan_Type_ID=@Plan_Type_ID and Plan_ID=@Plan_ID and Plan_Serial_Num=@Plan_Serial_Num and Plan_Code=@Plan_Code and Plan_Create_Time=@Plan_Create_Time and Plan_Begin_Time=@Plan_Begin_Time and Plan_End_Time=@Plan_End_Time and Plan_Bill_Time=@Plan_Bill_Time and Plan_Status=@Plan_Status and Plan_Operater=@Plan_Operater and Plan_From_Dept=@Plan_From_Dept and Plan_To_Dept=@Plan_To_Dept and Plan_From_User=@Plan_From_User and Plan_To_User=@Plan_To_User and Plan_Import_Flag=@Plan_Import_Flag and Plan_Remark=@Plan_Remark and Plan_Type_Code=@Plan_Type_Code and Plan_Type_Name=@Plan_Type_Name and Plan_Type_Group=@Plan_Type_Group and Plan_Type_Remark=@Plan_Type_Remark and Plan_Type_InOut=@Plan_Type_InOut and Plan_Type_Order=@Plan_Type_Order and Plan_Type_Flag=@Plan_Type_Flag ");
SqlParameter[] parameters =
{
new SqlParameter("@Plan_Type_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_ID", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Serial_Num", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Create_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Begin_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_End_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Bill_Time", SqlDbType.DateTime),
new SqlParameter("@Plan_Status", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Operater", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_From_Dept", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_To_Dept", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_From_User", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_To_User", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Import_Flag", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Group", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_InOut", SqlDbType.NVarChar, 50),
new SqlParameter("@Plan_Type_Order", SqlDbType.Int, 4),
new SqlParameter("@Plan_Type_Flag", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Plan_Type_ID;
parameters[1].Value = model.Plan_ID;
parameters[2].Value = model.Plan_Serial_Num;
parameters[3].Value = model.Plan_Code;
parameters[4].Value = model.Plan_Create_Time;
parameters[5].Value = model.Plan_Begin_Time;
parameters[6].Value = model.Plan_End_Time;
parameters[7].Value = model.Plan_Bill_Time;
parameters[8].Value = model.Plan_Status;
parameters[9].Value = model.Plan_Operater;
parameters[10].Value = model.Plan_From_Dept;
parameters[11].Value = model.Plan_To_Dept;
parameters[12].Value = model.Plan_From_User;
parameters[13].Value = model.Plan_To_User;
parameters[14].Value = model.Plan_Import_Flag;
parameters[15].Value = model.Plan_Remark;
parameters[16].Value = model.Plan_Type_Code;
parameters[17].Value = model.Plan_Type_Name;
parameters[18].Value = model.Plan_Type_Group;
parameters[19].Value = model.Plan_Type_Remark;
parameters[20].Value = model.Plan_Type_InOut;
parameters[21].Value = model.Plan_Type_Order;
parameters[22].Value = model.Plan_Type_Flag;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WMS_Database.View_PlanMainModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WMS_Database.View_PlanMainModel model)
{
return(dal.Add(model));
}
