using System;
using System.Data;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
using CommonFunc;
using System.Text;
using MESCS.Models;
namespace MESCS.Data
{
  public class data_carmaterialDb : IDisposable
  {
	public void Dispose()
	{
		Dispose(true);
		GC.SuppressFinalize(true);
	}
	protected virtual void Dispose(bool disposing)
	{
		if (!disposing)
		return;
	}
		///<summary>
		///判断是否存在记录
		///</summary>
		public bool Exists(string id)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("select count(1) from role");
			strSql.Append(" where ");
			strSql.Append(" id = @id  ");
			MySqlParameter[] parameters = {
			new MySqlParameter("@id", MySqlDbType.String)
			};
			 parameters[0].Value = id;
			return DbHelperSQLServer.Exists(strSql.ToString(), parameters);
		}
		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(data_carmaterialModel  model)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("insert into data_carmaterial(");
strSql.Append("id,carNo,materialNo,materialNm,materialBarno,IsDeleted,CreateTime,CreateId,CreateBy,ModifyTime,ModifyId,ModifyBy)");
 strSql.Append(" values (");
		strSql.Append("@id,@carNo,@materialNo,@materialNm,@materialBarno,@IsDeleted,@CreateTime,@CreateId,@CreateBy,@ModifyTime,@ModifyId,@ModifyBy)");
			strSql.Append("; ");
		MySqlParameter[] parameters = {
			 new MySqlParameter("@id",model.id),
			 new MySqlParameter("@carNo",model.carNo),
			 new MySqlParameter("@materialNo",model.materialNo),
			 new MySqlParameter("@materialNm",model.materialNm),
			 new MySqlParameter("@materialBarno",model.materialBarno),
			 new MySqlParameter("@IsDeleted",model.IsDeleted),
			 new MySqlParameter("@CreateTime",model.CreateTime),
			 new MySqlParameter("@CreateId",model.CreateId),
			 new MySqlParameter("@CreateBy",model.CreateBy),
			 new MySqlParameter("@ModifyTime",model.ModifyTime),
			 new MySqlParameter("@ModifyId",model.ModifyId),
			 new MySqlParameter("@ModifyBy",model.ModifyBy),
 			};
 			object obj = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
 			 if (obj == null)
 			 {
 			 return 0;
			 }
 			 else
 			 {
 			return Convert.ToInt32(obj);
 			}
		 }
		/// </summary>
		/// 修改一条数据
		/// </summary>
		 public bool Update(data_carmaterialModel  model)
		{
			StringBuilder strSql = new StringBuilder();
			strSql.Append("update  data_carmaterial set");
			strSql.Append( " carNo = @carNo , ");
			strSql.Append( " materialNo = @materialNo , ");
			strSql.Append( " materialNm = @materialNm , ");
			strSql.Append( " materialBarno = @materialBarno , ");
			strSql.Append( " IsDeleted = @IsDeleted , ");
			strSql.Append( " CreateTime = @CreateTime , ");
			strSql.Append( " CreateId = @CreateId , ");
			strSql.Append( " CreateBy = @CreateBy , ");
			strSql.Append( " ModifyTime = @ModifyTime , ");
			strSql.Append( " ModifyId = @ModifyId , ");
			strSql.Append(" ModifyBy = @ModifyBy");
			strSql.Append( " where  id = @id");
		MySqlParameter[] parameters = {
			 new MySqlParameter("@id", model.id),
			 new MySqlParameter("@carNo", model.carNo),
			 new MySqlParameter("@materialNo", model.materialNo),
			 new MySqlParameter("@materialNm", model.materialNm),
			 new MySqlParameter("@materialBarno", model.materialBarno),
			 new MySqlParameter("@IsDeleted", model.IsDeleted),
			 new MySqlParameter("@CreateTime", model.CreateTime),
			 new MySqlParameter("@CreateId", model.CreateId),
			 new MySqlParameter("@CreateBy", model.CreateBy),
			 new MySqlParameter("@ModifyTime", model.ModifyTime),
			 new MySqlParameter("@ModifyId", model.ModifyId),
			 new MySqlParameter("@ModifyBy", model.ModifyBy),
 			};
		 int rows = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
		 if (rows > 0)
		 {
		     return true;
		 }
		  else
		 {
		  return false;
		 }
	  }
		  /// <summary>
		  /// 删除一条数据
		  /// </summary>
		  public bool Delete(string id)
		  {
		   StringBuilder strSql = new StringBuilder();
		  strSql.Append("delete from role ");
		  strSql.Append(" where id=@id");
		  MySqlParameter[] parameters = {
		     new MySqlParameter("@id", MySqlDbType.String)
		  };
		      parameters[0].Value = id;
		    int rows = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
		    if (rows > 0)
		 {
		     return true;
		     }
		    else
		 {
		     return false;
		    }
		  }
		    /// <summary>
		   /// 得到一个对象实体
		   /// </summary>
		    public data_carmaterialModel  GetModel(string id)
		    {
			   StringBuilder strSql = new StringBuilder();
 			 strSql.Append("select");
			 strSql.Append(" id, carNo, materialNo, materialNm, materialBarno, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
		strSql.Append("  from data_carmaterial");
		   strSql.Append(" where id=@id");
		MySqlParameter[] parameters = {
		       new MySqlParameter("@id", MySqlDbType.String)
		  };
		  parameters[0].Value = id;
		  data_carmaterialModel model= new  data_carmaterialModel();
		  DataSet ds = DbHelperSQLServer.Query(strSql.ToString(), parameters);
		     if (ds.Tables[0].Rows.Count > 0)
		     {
		 if(ds.Tables[0].Rows[0]["id"] !=DBNull.Value)
		{
		 model.id =Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
		}
		 if(ds.Tables[0].Rows[0]["carNo"] !=DBNull.Value)
		{
		 model.carNo =Convert.ToString(ds.Tables[0].Rows[0]["carNo"]);
		}
		 if(ds.Tables[0].Rows[0]["materialNo"] !=DBNull.Value)
		{
		 model.materialNo =Convert.ToString(ds.Tables[0].Rows[0]["materialNo"]);
		}
		 if(ds.Tables[0].Rows[0]["materialNm"] !=DBNull.Value)
		{
		 model.materialNm =Convert.ToString(ds.Tables[0].Rows[0]["materialNm"]);
		}
		 if(ds.Tables[0].Rows[0]["materialBarno"] !=DBNull.Value)
		{
		 model.materialBarno =Convert.ToString(ds.Tables[0].Rows[0]["materialBarno"]);
		}
		 if(ds.Tables[0].Rows[0]["IsDeleted"] !=DBNull.Value)
		{
		 model.IsDeleted = ds.Tables[0].Rows[0]["IsDeleted"].ToString() == "False" ? false : true;
		}
		 if(ds.Tables[0].Rows[0]["CreateTime"] !=DBNull.Value)
		{
		 model.CreateTime =Convert.ToString(ds.Tables[0].Rows[0]["CreateTime"]);
		}
		 if(ds.Tables[0].Rows[0]["CreateId"] !=DBNull.Value)
		{
		 model.CreateId =Convert.ToInt32(ds.Tables[0].Rows[0]["CreateId"]);
		}
		 if(ds.Tables[0].Rows[0]["CreateBy"] !=DBNull.Value)
		{
		 model.CreateBy =Convert.ToString(ds.Tables[0].Rows[0]["CreateBy"]);
		}
		 if(ds.Tables[0].Rows[0]["ModifyTime"] !=DBNull.Value)
		{
		 model.ModifyTime =Convert.ToString(ds.Tables[0].Rows[0]["ModifyTime"]);
		}
		 if(ds.Tables[0].Rows[0]["ModifyId"] !=DBNull.Value)
		{
		 model.ModifyId =Convert.ToInt32(ds.Tables[0].Rows[0]["ModifyId"]);
		}
		 if(ds.Tables[0].Rows[0]["ModifyBy"] !=DBNull.Value)
		{
		 model.ModifyBy =Convert.ToString(ds.Tables[0].Rows[0]["ModifyBy"]);
		}
		 return model;
		}
		else{
		 return null;
		}
	  }
		    /// <summary>
		   /// 得到一个对象实体集合
		   /// </summary>
		    public List<data_carmaterialModel>  GetList(string strWhere)
		    {
			   StringBuilder strSql = new StringBuilder();
 			 strSql.Append("select");
			 strSql.Append(" id, carNo, materialNo, materialNm, materialBarno, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
		strSql.Append("  from data_carmaterial");
		  if( !string.IsNullOrWhiteSpace(strWhere))
		   strSql.Append(" where " + strWhere);
		  List<data_carmaterialModel> Items= new  List<data_carmaterialModel>();
		  DataSet ds = DbHelperSQLServer.Query(strSql.ToString());
		     if (ds.Tables[0].Rows.Count > 0)
		     {
		     foreach(DataRow row in ds.Tables[0].Rows)
		     {
		  data_carmaterialModel model= new  data_carmaterialModel();
		 if(row["id"] !=DBNull.Value)
		{
		 model.id =Convert.ToInt32(row["id"]);
		}
		 if(row["carNo"] !=DBNull.Value)
		{
		 model.carNo =Convert.ToString(row["carNo"]);
		}
		 if(row["materialNo"] !=DBNull.Value)
		{
		 model.materialNo =Convert.ToString(row["materialNo"]);
		}
		 if(row["materialNm"] !=DBNull.Value)
		{
		 model.materialNm =Convert.ToString(row["materialNm"]);
		}
		 if(row["materialBarno"] !=DBNull.Value)
		{
		 model.materialBarno =Convert.ToString(row["materialBarno"]);
		}
		 if(row["IsDeleted"] !=DBNull.Value)
		{
		 model.IsDeleted = row["IsDeleted"].ToString() == "False" ? false : true;
		}
		 if(row["CreateTime"] !=DBNull.Value)
		{
		 model.CreateTime =Convert.ToString(row["CreateTime"]);
		}
		 if(row["CreateId"] !=DBNull.Value)
		{
		 model.CreateId =Convert.ToInt32(row["CreateId"]);
		}
		 if(row["CreateBy"] !=DBNull.Value)
		{
		 model.CreateBy =Convert.ToString(row["CreateBy"]);
		}
		 if(row["ModifyTime"] !=DBNull.Value)
		{
		 model.ModifyTime =Convert.ToString(row["ModifyTime"]);
		}
		 if(row["ModifyId"] !=DBNull.Value)
		{
		 model.ModifyId =Convert.ToInt32(row["ModifyId"]);
		}
		 if(row["ModifyBy"] !=DBNull.Value)
		{
		 model.ModifyBy =Convert.ToString(row["ModifyBy"]);
		}
		 Items.Add(model);
		}
		}
		 return Items;
		}
		    /// <summary>
		   /// 得到一个对象实体集合
		   /// </summary>
		    public List<data_carmaterialModel>  GetList(string strWhere,MySqlParameter[] parameters)
		    {
			   StringBuilder strSql = new StringBuilder();
			  strSql.Append("select");
			 strSql.Append(" id, carNo, materialNo, materialNm, materialBarno, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s')  CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s')  ModifyTime, ModifyId, ModifyBy");
		strSql.Append("  from data_carmaterial");
		  if( !string.IsNullOrWhiteSpace(strWhere))
		   strSql.Append(" where " + strWhere);
		  List<data_carmaterialModel> Items= new  List<data_carmaterialModel>();
		  DataSet ds = DbHelperSQLServer.Query(strSql.ToString(), parameters);
		     if (ds.Tables[0].Rows.Count > 0)
		     {
		     foreach(DataRow row in ds.Tables[0].Rows)
		     {
		  data_carmaterialModel model= new  data_carmaterialModel();
		 if(row["id"] !=DBNull.Value)
		{
		 model.id =Convert.ToInt32(row["id"]);
		}
		 if(row["carNo"] !=DBNull.Value)
		{
		 model.carNo =Convert.ToString(row["carNo"]);
		}
		 if(row["materialNo"] !=DBNull.Value)
		{
		 model.materialNo =Convert.ToString(row["materialNo"]);
		}
		 if(row["materialNm"] !=DBNull.Value)
		{
		 model.materialNm =Convert.ToString(row["materialNm"]);
		}
		 if(row["materialBarno"] !=DBNull.Value)
		{
		 model.materialBarno =Convert.ToString(row["materialBarno"]);
		}
		 if(row["IsDeleted"] !=DBNull.Value)
		{
		 model.IsDeleted = row["IsDeleted"].ToString() == "False" ? false : true;
		}
		 if(row["CreateTime"] !=DBNull.Value)
		{
		 model.CreateTime =Convert.ToString(row["CreateTime"]);
		}
		 if(row["CreateId"] !=DBNull.Value)
		{
		 model.CreateId =Convert.ToInt32(row["CreateId"]);
		}
		 if(row["CreateBy"] !=DBNull.Value)
		{
		 model.CreateBy =Convert.ToString(row["CreateBy"]);
		}
		 if(row["ModifyTime"] !=DBNull.Value)
		{
		 model.ModifyTime =Convert.ToString(row["ModifyTime"]);
		}
		 if(row["ModifyId"] !=DBNull.Value)
		{
		 model.ModifyId =Convert.ToInt32(row["ModifyId"]);
		}
		 if(row["ModifyBy"] !=DBNull.Value)
		{
		 model.ModifyBy =Convert.ToString(row["ModifyBy"]);
		}
		 Items.Add(model);
		}
		}
		 return Items;
		}
  }
}