/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.OrgProviderInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OrgProviderInfo(");
strSql.Append("OrgId,BankAccount,BankName,BankAddress,Manager,ManagerPhone,ProviderType,AddTime)");
strSql.Append(" values (");
strSql.Append("@OrgId,@BankAccount,@BankName,@BankAddress,@Manager,@ManagerPhone,@ProviderType,@AddTime)");
strSql.Append(";select @@IDENTITY");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "OrgId", DbType.Int64, model.OrgId);
db.AddInParameter(dbCommand, "BankAccount", DbType.AnsiString, model.BankAccount);
db.AddInParameter(dbCommand, "BankName", DbType.String, model.BankName);
db.AddInParameter(dbCommand, "BankAddress", DbType.String, model.BankAddress);
db.AddInParameter(dbCommand, "Manager", DbType.String, model.Manager);
db.AddInParameter(dbCommand, "ManagerPhone", DbType.AnsiString, model.ManagerPhone);
db.AddInParameter(dbCommand, "ProviderType", DbType.String, model.ProviderType);
db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public Model.OrgProviderInfo ReaderBind(IDataReader dataReader)
{
Model.OrgProviderInfo model = new Model.OrgProviderInfo();
object ojb;
ojb = dataReader["ProvId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ProvId = Convert.ToInt32(ojb);
}
ojb = dataReader["OrgId"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrgId = Convert.ToInt64(ojb);
}
model.BankAccount = dataReader["BankAccount"].ToString();
model.BankName = dataReader["BankName"].ToString();
model.BankAddress = dataReader["BankAddress"].ToString();
model.Manager = dataReader["Manager"].ToString();
model.ManagerPhone = dataReader["ManagerPhone"].ToString();
model.ProviderType = dataReader["ProviderType"].ToString();
ojb = dataReader["AddTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.AddTime = Convert.ToDateTime(ojb);
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.OrgProviderInfo DataRowToModel(DataRow row)
{
Model.OrgProviderInfo model=new Model.OrgProviderInfo();
if (row != null)
{
if(row["ProvId"]!=null && row["ProvId"].ToString()!="")
{
model.ProvId=Convert.ToInt32(row["ProvId"].ToString());
}
if(row["OrgId"]!=null && row["OrgId"].ToString()!="")
{
model.OrgId=Convert.ToInt64(row["OrgId"].ToString());
}
if(row["BankAccount"]!=null)
{
model.BankAccount=row["BankAccount"].ToString();
}
if(row["BankName"]!=null)
{
model.BankName=row["BankName"].ToString();
}
if(row["BankAddress"]!=null)
{
model.BankAddress=row["BankAddress"].ToString();
}
if(row["Manager"]!=null)
{
model.Manager=row["Manager"].ToString();
}
if(row["ManagerPhone"]!=null)
{
model.ManagerPhone=row["ManagerPhone"].ToString();
}
if(row["ProviderType"]!=null)
{
model.ProviderType=row["ProviderType"].ToString();
}
if(row["AddTime"]!=null && row["AddTime"].ToString()!="")
{
model.AddTime=Convert.ToDateTime(row["AddTime"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.OrgProviderInfo DataRowToModel(DataRow row)
{
Model.OrgProviderInfo model = new Model.OrgProviderInfo();
if (row != null)
{
if (row["ProvId"] != null && row["ProvId"].ToString() != "")
{
model.ProvId = Convert.ToInt32(row["ProvId"].ToString());
}
if (row["OrgId"] != null && row["OrgId"].ToString() != "")
{
model.OrgId = Convert.ToInt64(row["OrgId"].ToString());
}
if (row["BankAccount"] != null)
{
model.BankAccount = row["BankAccount"].ToString();
}
if (row["BankName"] != null)
{
model.BankName = row["BankName"].ToString();
}
if (row["BankAddress"] != null)
{
model.BankAddress = row["BankAddress"].ToString();
}
if (row["Manager"] != null)
{
model.Manager = row["Manager"].ToString();
}
if (row["ManagerPhone"] != null)
{
model.ManagerPhone = row["ManagerPhone"].ToString();
}
if (row["ProviderType"] != null)
{
model.ProviderType = row["ProviderType"].ToString();
}
if (row["AddTime"] != null && row["AddTime"].ToString() != "")
{
model.AddTime = Convert.ToDateTime(row["AddTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.OrgProviderInfo GetModel(int ProvId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ProvId,OrgId,BankAccount,BankName,BankAddress,Manager,ManagerPhone,ProviderType,AddTime from OrgProviderInfo ");
strSql.Append(" where ProvId=@ProvId ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ProvId", DbType.Int32, ProvId);
Model.OrgProviderInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.OrgProviderInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OrgProviderInfo set ");
strSql.Append("OrgId=@OrgId,");
strSql.Append("BankAccount=@BankAccount,");
strSql.Append("BankName=@BankName,");
strSql.Append("BankAddress=@BankAddress,");
strSql.Append("Manager=@Manager,");
strSql.Append("ManagerPhone=@ManagerPhone,");
strSql.Append("ProviderType=@ProviderType,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ProvId=@ProvId ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ProvId", DbType.Int32, model.ProvId);
db.AddInParameter(dbCommand, "OrgId", DbType.Int64, model.OrgId);
db.AddInParameter(dbCommand, "BankAccount", DbType.AnsiString, model.BankAccount);
db.AddInParameter(dbCommand, "BankName", DbType.String, model.BankName);
db.AddInParameter(dbCommand, "BankAddress", DbType.String, model.BankAddress);
db.AddInParameter(dbCommand, "Manager", DbType.String, model.Manager);
db.AddInParameter(dbCommand, "ManagerPhone", DbType.AnsiString, model.ManagerPhone);
db.AddInParameter(dbCommand, "ProviderType", DbType.String, model.ProviderType);
db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public Model.OrgProviderInfo ReaderBind(IDataReader dataReader)
{
Model.OrgProviderInfo model=new Model.OrgProviderInfo();
object ojb;
ojb = dataReader["ProvId"];
if(ojb != null && ojb != DBNull.Value)
{
model.ProvId=Convert.ToInt32(ojb);
}
ojb = dataReader["OrgId"];
if(ojb != null && ojb != DBNull.Value)
{
model.OrgId=Convert.ToInt64(ojb);
}
model.BankAccount=dataReader["BankAccount"].ToString();
model.BankName=dataReader["BankName"].ToString();
model.BankAddress=dataReader["BankAddress"].ToString();
model.Manager=dataReader["Manager"].ToString();
model.ManagerPhone=dataReader["ManagerPhone"].ToString();
model.ProviderType=dataReader["ProviderType"].ToString();
ojb = dataReader["AddTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.AddTime=Convert.ToDateTime(ojb);
}
return model;
}
