/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Add(yny_005.Model.C_CarTast model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into C_CarTast(");
strSql.Append("Name,TType,SupplierName,SupplierAddress,SupplierTelName,SupplierTel,CarID,CarSJ1,CarSJ2,CostType,BDImg,TState,IsDelete,Spare1,Spare2,OCode,CSpare2,ComDate,XSMID,DDMID,Prot)");
strSql.Append(" values (");
strSql.Append("@Name,@TType,@SupplierName,@SupplierAddress,@SupplierTelName,@SupplierTel,@CarID,@CarSJ1,@CarSJ2,@CostType,@BDImg,@TState,@IsDelete,@Spare1,@Spare2,@OCode,@CSpare2,@ComDate,@XSMID,@DDMID,@Prot)");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 150),
new SqlParameter("@TType", SqlDbType.Int, 4),
new SqlParameter("@SupplierName", SqlDbType.VarChar, 50),
new SqlParameter("@SupplierAddress", SqlDbType.VarChar, 150),
new SqlParameter("@SupplierTelName", SqlDbType.VarChar, 50),
new SqlParameter("@SupplierTel", SqlDbType.VarChar, 50),
new SqlParameter("@CarID", SqlDbType.Int, 4),
new SqlParameter("@CarSJ1", SqlDbType.VarChar, 50),
new SqlParameter("@CarSJ2", SqlDbType.VarChar, 50),
new SqlParameter("@CostType", SqlDbType.Int, 4),
new SqlParameter("@BDImg", SqlDbType.VarChar, 250),
new SqlParameter("@TState", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@Spare1", SqlDbType.VarChar, 250),
new SqlParameter("@Spare2", SqlDbType.VarChar, 250),
//new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@OCode", SqlDbType.VarChar, 50),
new SqlParameter("@CSpare2", SqlDbType.VarChar, 50),
new SqlParameter("@ComDate", SqlDbType.DateTime), new SqlParameter("@XSMID",SqlDbType.VarChar,50), new SqlParameter("@DDMID", SqlDbType.VarChar, 50), new SqlParameter("@Prot", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.TType;
parameters[2].Value = model.SupplierName;
parameters[3].Value = model.SupplierAddress;
parameters[4].Value = model.SupplierTelName;
parameters[5].Value = model.SupplierTel;
parameters[6].Value = model.CarID;
parameters[7].Value = model.CarSJ1;
parameters[8].Value = model.CarSJ2;
parameters[9].Value = model.CostType;
parameters[10].Value = model.BDImg;
parameters[11].Value = model.TState;
parameters[12].Value = model.IsDelete;
parameters[13].Value = model.Spare1;
parameters[14].Value = model.Spare2;
//parameters[15].Value = model.CreateDate;
parameters[15].Value = model.OCode;
parameters[16].Value = model.CSpare2;
parameters[17].Value = model.ComDate;
parameters[18].Value = model.XSMID;
parameters[19].Value = model.DDMID;
parameters[20].Value = model.Prot;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static Model.C_CarTast GetModelBySJ(string mid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,TType,SupplierName,SupplierAddress,SupplierTelName,SupplierTel,CarID,CarSJ1,CarSJ2,CostType,BDImg,TState,IsDelete,Spare1,Spare2,CreateDate,OCode,CSpare2,ComDate,XSMID,DDMID,Prot from C_CarTast ");
strSql.AppendFormat(" where (CarSJ1='{0}' or CarSJ2='{0}') and TState=0;", mid);
yny_005.Model.C_CarTast model = new yny_005.Model.C_CarTast();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static yny_005.Model.C_CarTast GetModelname(string name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,TType,SupplierName,SupplierAddress,SupplierTelName,SupplierTel,CarID,CarSJ1,CarSJ2,CostType,BDImg,TState,IsDelete,Spare1,Spare2,CreateDate,OCode,CSpare2,ComDate,XSMID,DDMID,Prot from C_CarTast ");
strSql.Append(" where Name=@Name");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 50)
};
parameters[0].Value = name;
yny_005.Model.C_CarTast model = new yny_005.Model.C_CarTast();
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 static int Add(yny_005.Model.C_CarTast model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into C_CarTast(");
strSql.Append("Name,TType,SupplierName,SupplierAddress,SupplierTelName,SupplierTel,CarID,CarSJ1,CarSJ2,CostType,BDImg,TState,IsDelete,Spare1,Spare2,OCode,CSpare2,ComDate,XSMID,DDMID,Prot)");
strSql.Append(" values (");
strSql.Append("@Name,@TType,@SupplierName,@SupplierAddress,@SupplierTelName,@SupplierTel,@CarID,@CarSJ1,@CarSJ2,@CostType,@BDImg,@TState,@IsDelete,@Spare1,@Spare2,@OCode,@CSpare2,@ComDate,@XSMID,@DDMID,@Prot)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 150),
new SqlParameter("@TType", SqlDbType.Int, 4),
new SqlParameter("@SupplierName", SqlDbType.VarChar, 50),
new SqlParameter("@SupplierAddress", SqlDbType.VarChar, 150),
new SqlParameter("@SupplierTelName", SqlDbType.VarChar, 50),
new SqlParameter("@SupplierTel", SqlDbType.VarChar, 50),
new SqlParameter("@CarID", SqlDbType.Int, 4),
new SqlParameter("@CarSJ1", SqlDbType.VarChar, 50),
new SqlParameter("@CarSJ2", SqlDbType.VarChar, 50),
new SqlParameter("@CostType", SqlDbType.Int, 4),
new SqlParameter("@BDImg", SqlDbType.VarChar, 250),
new SqlParameter("@TState", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@Spare1", SqlDbType.VarChar, 250),
new SqlParameter("@Spare2", SqlDbType.VarChar, 250),
//new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@OCode", SqlDbType.VarChar, 50),
new SqlParameter("@CSpare2", SqlDbType.VarChar, 50),
new SqlParameter("@ComDate", SqlDbType.DateTime), new SqlParameter("@XSMID",SqlDbType.VarChar,50), new SqlParameter("@XSMID", SqlDbType.VarChar, 50), new SqlParameter("@Prot", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.TType;
parameters[2].Value = model.SupplierName;
parameters[3].Value = model.SupplierAddress;
parameters[4].Value = model.SupplierTelName;
parameters[5].Value = model.SupplierTel;
parameters[6].Value = model.CarID;
parameters[7].Value = model.CarSJ1;
parameters[8].Value = model.CarSJ2;
parameters[9].Value = model.CostType;
parameters[10].Value = model.BDImg;
parameters[11].Value = model.TState;
parameters[12].Value = model.IsDelete;
parameters[13].Value = model.Spare1;
parameters[14].Value = model.Spare2;
//parameters[15].Value = model.CreateDate;
parameters[15].Value = model.OCode;
parameters[16].Value = model.CSpare2;
parameters[17].Value = model.ComDate;
parameters[18].Value = model.XSMID;
parameters[19].Value = model.DDMID;
parameters[20].Value = model.Prot;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static yny_005.Model.C_CarTast DataRowToModel(DataRow row)
{
yny_005.Model.C_CarTast model = new yny_005.Model.C_CarTast();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["TType"] != null && row["TType"].ToString() != "")
{
model.TType = int.Parse(row["TType"].ToString());
}
if (row["SupplierName"] != null)
{
model.SupplierName = row["SupplierName"].ToString();
}
if (row["SupplierAddress"] != null)
{
model.SupplierAddress = row["SupplierAddress"].ToString();
}
if (row["SupplierTelName"] != null)
{
model.SupplierTelName = row["SupplierTelName"].ToString();
}
if (row["SupplierTel"] != null)
{
model.SupplierTel = row["SupplierTel"].ToString();
}
if (row["CarID"] != null && row["CarID"].ToString() != "")
{
model.CarID = int.Parse(row["CarID"].ToString());
}
if (row["CarSJ1"] != null)
{
model.CarSJ1 = row["CarSJ1"].ToString();
}
if (row["CarSJ2"] != null)
{
model.CarSJ2 = row["CarSJ2"].ToString();
}
if (row["CostType"] != null && row["CostType"].ToString() != "")
{
model.CostType = int.Parse(row["CostType"].ToString());
}
if (row["BDImg"] != null)
{
model.BDImg = row["BDImg"].ToString();
}
if (row["TState"] != null && row["TState"].ToString() != "")
{
model.TState = int.Parse(row["TState"].ToString());
}
if (row["IsDelete"] != null && row["IsDelete"].ToString() != "")
{
model.IsDelete = int.Parse(row["IsDelete"].ToString());
}
if (row["Spare1"] != null)
{
model.Spare1 = row["Spare1"].ToString();
}
if (row["Spare2"] != null)
{
model.Spare2 = row["Spare2"].ToString();
}
if (row["CreateDate"] != null)
{
model.CreateDate = DateTime.Parse(row["CreateDate"].ToString());
}
if (row["OCode"] != null)
{
model.OCode = row["OCode"].ToString();
}
if (row["CSpare2"] != null)
{
model.CSpare2 = row["CSpare2"].ToString();
}
if (row["ComDate"] != null)
{
model.ComDate = DateTime.Parse(row["ComDate"].ToString());
}
if (row["XSMID"] != null)
{
model.XSMID = row["XSMID"].ToString();
}
if (row["DDMID"] != null)
{
model.DDMID = row["DDMID"].ToString();
}
if (row["Prot"] != null && row["Prot"].ToString() != "")
{
model.Prot = int.Parse(row["Prot"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static Hashtable Update(yny_005.Model.C_CarTast model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update C_CarTast set ");
strSql.Append("Name=@Name,");
strSql.Append("TType=@TType,");
strSql.Append("SupplierName=@SupplierName,");
strSql.Append("SupplierAddress=@SupplierAddress,");
strSql.Append("SupplierTelName=@SupplierTelName,");
strSql.Append("SupplierTel=@SupplierTel,");
strSql.Append("CarID=@CarID,");
strSql.Append("CarSJ1=@CarSJ1,");
strSql.Append("CarSJ2=@CarSJ2,");
strSql.Append("CostType=@CostType,");
strSql.Append("BDImg=@BDImg,");
strSql.Append("TState=@TState,");
strSql.Append("IsDelete=@IsDelete,");
strSql.Append("Spare1=@Spare1,");
strSql.Append("Spare2=@Spare2,");
//strSql.Append("CreateDate=@CreateDate,");
strSql.Append("OCode=@OCode,");
strSql.Append("CSpare2=@CSpare2,");
strSql.Append("ComDate=@ComDate,");
strSql.Append("XSMID=@XSMID,");
strSql.Append("DDMID=@DDMID,");
strSql.Append("Prot=@Prot");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 150),
new SqlParameter("@TType", SqlDbType.Int, 4),
new SqlParameter("@SupplierName", SqlDbType.VarChar, 50),
new SqlParameter("@SupplierAddress", SqlDbType.VarChar, 150),
new SqlParameter("@SupplierTelName", SqlDbType.VarChar, 50),
new SqlParameter("@SupplierTel", SqlDbType.VarChar, 50),
new SqlParameter("@CarID", SqlDbType.Int, 4),
new SqlParameter("@CarSJ1", SqlDbType.VarChar, 50),
new SqlParameter("@CarSJ2", SqlDbType.VarChar, 50),
new SqlParameter("@CostType", SqlDbType.Int, 4),
new SqlParameter("@BDImg", SqlDbType.VarChar, 250),
new SqlParameter("@TState", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@Spare1", SqlDbType.VarChar, 250),
new SqlParameter("@Spare2", SqlDbType.VarChar, 250),
//new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@OCode", SqlDbType.VarChar, 50),
new SqlParameter("@CSpare2", SqlDbType.VarChar, 50),
new SqlParameter("@ComDate", SqlDbType.DateTime),
new SqlParameter("@XSMID", SqlDbType.VarChar, 50),
new SqlParameter("@DDMID", SqlDbType.VarChar, 50),
new SqlParameter("@Prot", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.TType;
parameters[2].Value = model.SupplierName;
parameters[3].Value = model.SupplierAddress;
parameters[4].Value = model.SupplierTelName;
parameters[5].Value = model.SupplierTel;
parameters[6].Value = model.CarID;
parameters[7].Value = model.CarSJ1;
parameters[8].Value = model.CarSJ2;
parameters[9].Value = model.CostType;
parameters[10].Value = model.BDImg;
parameters[11].Value = model.TState;
parameters[12].Value = model.IsDelete;
parameters[13].Value = model.Spare1;
parameters[14].Value = model.Spare2;
//parameters[15].Value = model.CreateDate;
parameters[15].Value = model.OCode;
parameters[16].Value = model.CSpare2;
parameters[17].Value = model.ComDate;
parameters[18].Value = model.XSMID;
parameters[19].Value = model.DDMID;
parameters[20].Value = model.Prot;
parameters[21].Value = model.ID;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
