/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(YueYePlat.Model.driverinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into driverinfo(");
strSql.Append("DriverId,DriverName,DriverSex,FamilyAddress,Mobile,IdNumber,DriverLicense,LicenseType,DriverLocation,EmergencyContact,EmergencyMobile,EmergencyRelations,DriverPhoto,CompanyId,Type)");
strSql.Append(" values (");
strSql.Append("@DriverId,@DriverName,@DriverSex,@FamilyAddress,@Mobile,@IdNumber,@DriverLicense,@LicenseType,@DriverLocation,@EmergencyContact,@EmergencyMobile,@EmergencyRelations,@DriverPhoto,@CompanyId,@Type)");
MySqlParameter[] parameters =
{
new MySqlParameter("@DriverId", MySqlDbType.VarChar, 10),
new MySqlParameter("@DriverName", MySqlDbType.VarChar, 50),
new MySqlParameter("@DriverSex", MySqlDbType.VarChar, 2),
new MySqlParameter("@FamilyAddress", MySqlDbType.VarChar, 300),
new MySqlParameter("@Mobile", MySqlDbType.VarChar, 20),
new MySqlParameter("@IdNumber", MySqlDbType.VarChar, 30),
new MySqlParameter("@DriverLicense", MySqlDbType.VarChar, 30),
new MySqlParameter("@LicenseType", MySqlDbType.VarChar, 20),
new MySqlParameter("@DriverLocation", MySqlDbType.VarChar, 20),
new MySqlParameter("@EmergencyContact", MySqlDbType.VarChar, 50),
new MySqlParameter("@EmergencyMobile", MySqlDbType.VarChar, 20),
new MySqlParameter("@EmergencyRelations", MySqlDbType.VarChar, 10),
new MySqlParameter("@DriverPhoto", MySqlDbType.VarChar, 300),
new MySqlParameter("@CompanyId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Type", MySqlDbType.VarChar, 20)
};
parameters[0].Value = model.DriverId;
parameters[1].Value = model.DriverName;
parameters[2].Value = model.DriverSex;
parameters[3].Value = model.FamilyAddress;
parameters[4].Value = model.Mobile;
parameters[5].Value = model.IdNumber;
parameters[6].Value = model.DriverLicense;
parameters[7].Value = model.LicenseType;
parameters[8].Value = model.DriverLocation;
parameters[9].Value = model.EmergencyContact;
parameters[10].Value = model.EmergencyMobile;
parameters[11].Value = model.EmergencyRelations;
parameters[12].Value = model.DriverPhoto;
parameters[13].Value = model.CompanyId;
parameters[14].Value = model.Type;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YueYePlat.Model.driverinfo GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,DriverId,DriverName,DriverSex,FamilyAddress,Mobile,IdNumber,DriverLicense,LicenseType,DriverLocation,EmergencyContact,EmergencyMobile,EmergencyRelations,DriverPhoto,CompanyId,Type from driverinfo ");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
};
parameters[0].Value = Id;
YueYePlat.Model.driverinfo model = new YueYePlat.Model.driverinfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public YueYePlat.Model.driverinfo DataRowToModel(DataRow row)
{
YueYePlat.Model.driverinfo model = new YueYePlat.Model.driverinfo();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["DriverId"] != null)
{
model.DriverId = row["DriverId"].ToString();
}
if (row["DriverName"] != null)
{
model.DriverName = row["DriverName"].ToString();
}
if (row["DriverSex"] != null)
{
model.DriverSex = row["DriverSex"].ToString();
}
if (row["FamilyAddress"] != null)
{
model.FamilyAddress = row["FamilyAddress"].ToString();
}
if (row["Mobile"] != null)
{
model.Mobile = row["Mobile"].ToString();
}
if (row["IdNumber"] != null)
{
model.IdNumber = row["IdNumber"].ToString();
}
if (row["DriverLicense"] != null)
{
model.DriverLicense = row["DriverLicense"].ToString();
}
if (row["LicenseType"] != null)
{
model.LicenseType = row["LicenseType"].ToString();
}
if (row["DriverLocation"] != null)
{
model.DriverLocation = row["DriverLocation"].ToString();
}
if (row["EmergencyContact"] != null)
{
model.EmergencyContact = row["EmergencyContact"].ToString();
}
if (row["EmergencyMobile"] != null)
{
model.EmergencyMobile = row["EmergencyMobile"].ToString();
}
if (row["EmergencyRelations"] != null)
{
model.EmergencyRelations = row["EmergencyRelations"].ToString();
}
if (row["DriverPhoto"] != null)
{
model.DriverPhoto = row["DriverPhoto"].ToString();
}
if (row["CompanyId"] != null)
{
model.CompanyId = row["CompanyId"].ToString();
}
if (row["Type"] != null)
{
model.Type = row["Type"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(YueYePlat.Model.driverinfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update driverinfo set ");
strSql.Append("DriverId=@DriverId,");
strSql.Append("DriverName=@DriverName,");
strSql.Append("DriverSex=@DriverSex,");
strSql.Append("FamilyAddress=@FamilyAddress,");
strSql.Append("Mobile=@Mobile,");
strSql.Append("IdNumber=@IdNumber,");
strSql.Append("DriverLicense=@DriverLicense,");
strSql.Append("LicenseType=@LicenseType,");
strSql.Append("DriverLocation=@DriverLocation,");
strSql.Append("EmergencyContact=@EmergencyContact,");
strSql.Append("EmergencyMobile=@EmergencyMobile,");
strSql.Append("EmergencyRelations=@EmergencyRelations,");
strSql.Append("DriverPhoto=@DriverPhoto,");
strSql.Append("CompanyId=@CompanyId,");
strSql.Append("Type=@Type");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@DriverId", MySqlDbType.VarChar, 10),
new MySqlParameter("@DriverName", MySqlDbType.VarChar, 50),
new MySqlParameter("@DriverSex", MySqlDbType.VarChar, 2),
new MySqlParameter("@FamilyAddress", MySqlDbType.VarChar, 300),
new MySqlParameter("@Mobile", MySqlDbType.VarChar, 20),
new MySqlParameter("@IdNumber", MySqlDbType.VarChar, 30),
new MySqlParameter("@DriverLicense", MySqlDbType.VarChar, 30),
new MySqlParameter("@LicenseType", MySqlDbType.VarChar, 20),
new MySqlParameter("@DriverLocation", MySqlDbType.VarChar, 20),
new MySqlParameter("@EmergencyContact", MySqlDbType.VarChar, 50),
new MySqlParameter("@EmergencyMobile", MySqlDbType.VarChar, 20),
new MySqlParameter("@EmergencyRelations", MySqlDbType.VarChar, 10),
new MySqlParameter("@DriverPhoto", MySqlDbType.VarChar, 300),
new MySqlParameter("@CompanyId", MySqlDbType.VarChar, 50),
new MySqlParameter("@Type", MySqlDbType.VarChar, 20),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.DriverId;
parameters[1].Value = model.DriverName;
parameters[2].Value = model.DriverSex;
parameters[3].Value = model.FamilyAddress;
parameters[4].Value = model.Mobile;
parameters[5].Value = model.IdNumber;
parameters[6].Value = model.DriverLicense;
parameters[7].Value = model.LicenseType;
parameters[8].Value = model.DriverLocation;
parameters[9].Value = model.EmergencyContact;
parameters[10].Value = model.EmergencyMobile;
parameters[11].Value = model.EmergencyRelations;
parameters[12].Value = model.DriverPhoto;
parameters[13].Value = model.CompanyId;
parameters[14].Value = model.Type;
parameters[15].Value = model.Id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
