/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.PayForAnotherInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PayForAnotherInfo set ");
strSql.Append(" p_auditortime = @p_auditortime , ");
strSql.Append(" p_append = @p_append , ");
strSql.Append(" p_appendtime = @p_appendtime , ");
strSql.Append(" p_InterfaceName = @p_InterfaceName , ");
strSql.Append(" p_InterfaceType = @p_InterfaceType , ");
strSql.Append(" p_MerchantNumber = @p_MerchantNumber , ");
strSql.Append(" p_KeyType = @p_KeyType , ");
strSql.Append(" p_PrivateKey = @p_PrivateKey , ");
strSql.Append(" p_PublicKey = @p_PublicKey , ");
strSql.Append(" IsEnabled = @IsEnabled , ");
strSql.Append(" p_auditor = @p_auditor ");
strSql.Append(" where p_Id=@p_Id ");
SqlParameter[] parameters =
{
new SqlParameter("@p_Id", SqlDbType.Int, 4),
new SqlParameter("@p_auditortime", SqlDbType.DateTime),
new SqlParameter("@p_append", SqlDbType.NVarChar, 200),
new SqlParameter("@p_appendtime", SqlDbType.DateTime),
new SqlParameter("@p_InterfaceName", SqlDbType.NVarChar, 200),
new SqlParameter("@p_InterfaceType", SqlDbType.Int, 4),
new SqlParameter("@p_MerchantNumber", SqlDbType.NVarChar, 200),
new SqlParameter("@p_KeyType", SqlDbType.Int, 4),
new SqlParameter("@p_PrivateKey", SqlDbType.NVarChar, 500),
new SqlParameter("@p_PublicKey", SqlDbType.NVarChar, 500),
new SqlParameter("@IsEnabled", SqlDbType.Bit, 1),
new SqlParameter("@p_auditor", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.p_Id;
parameters[1].Value = model.p_auditortime;
parameters[2].Value = model.p_append;
parameters[3].Value = model.p_appendtime;
parameters[4].Value = model.p_InterfaceName;
parameters[5].Value = model.p_InterfaceType;
parameters[6].Value = model.p_MerchantNumber;
parameters[7].Value = model.p_KeyType;
parameters[8].Value = model.p_PrivateKey;
parameters[9].Value = model.p_PublicKey;
parameters[10].Value = model.IsEnabled;
parameters[11].Value = model.p_auditor;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <JMP.MDL.PayForAnotherInfo> DataTableToList(DataTable dt)
{
List <JMP.MDL.PayForAnotherInfo> modelList = new List <JMP.MDL.PayForAnotherInfo>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
JMP.MDL.PayForAnotherInfo model;
for (int n = 0; n < rowsCount; n++)
{
model = new JMP.MDL.PayForAnotherInfo();
if (dt.Rows[n]["p_Id"].ToString() != "")
{
model.p_Id = int.Parse(dt.Rows[n]["p_Id"].ToString());
}
if (dt.Rows[n]["p_auditortime"].ToString() != "")
{
model.p_auditortime = DateTime.Parse(dt.Rows[n]["p_auditortime"].ToString());
}
model.p_append = dt.Rows[n]["p_append"].ToString();
if (dt.Rows[n]["p_appendtime"].ToString() != "")
{
model.p_appendtime = DateTime.Parse(dt.Rows[n]["p_appendtime"].ToString());
}
model.p_InterfaceName = dt.Rows[n]["p_InterfaceName"].ToString();
if (dt.Rows[n]["p_InterfaceType"].ToString() != "")
{
model.p_InterfaceType = int.Parse(dt.Rows[n]["p_InterfaceType"].ToString());
}
model.p_MerchantNumber = dt.Rows[n]["p_MerchantNumber"].ToString();
if (dt.Rows[n]["p_KeyType"].ToString() != "")
{
model.p_KeyType = int.Parse(dt.Rows[n]["p_KeyType"].ToString());
}
model.p_PrivateKey = dt.Rows[n]["p_PrivateKey"].ToString();
model.p_PublicKey = dt.Rows[n]["p_PublicKey"].ToString();
if (dt.Rows[n]["IsEnabled"].ToString() != "")
{
if ((dt.Rows[n]["IsEnabled"].ToString() == "1") || (dt.Rows[n]["IsEnabled"].ToString().ToLower() == "true"))
{
model.IsEnabled = true;
}
else
{
model.IsEnabled = false;
}
}
model.p_auditor = dt.Rows[n]["p_auditor"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.PayForAnotherInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PayForAnotherInfo(");
strSql.Append("p_auditortime,p_append,p_appendtime,p_InterfaceName,p_InterfaceType,p_MerchantNumber,p_KeyType,p_PrivateKey,p_PublicKey,IsEnabled,p_auditor");
strSql.Append(") values (");
strSql.Append("@p_auditortime,@p_append,@p_appendtime,@p_InterfaceName,@p_InterfaceType,@p_MerchantNumber,@p_KeyType,@p_PrivateKey,@p_PublicKey,@IsEnabled,@p_auditor");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@p_auditortime", SqlDbType.DateTime),
new SqlParameter("@p_append", SqlDbType.NVarChar, 200),
new SqlParameter("@p_appendtime", SqlDbType.DateTime),
new SqlParameter("@p_InterfaceName", SqlDbType.NVarChar, 200),
new SqlParameter("@p_InterfaceType", SqlDbType.Int, 4),
new SqlParameter("@p_MerchantNumber", SqlDbType.NVarChar, 200),
new SqlParameter("@p_KeyType", SqlDbType.Int, 4),
new SqlParameter("@p_PrivateKey", SqlDbType.NVarChar, 500),
new SqlParameter("@p_PublicKey", SqlDbType.NVarChar, 500),
new SqlParameter("@IsEnabled", SqlDbType.Bit, 1),
new SqlParameter("@p_auditor", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.p_auditortime;
parameters[1].Value = model.p_append;
parameters[2].Value = model.p_appendtime;
parameters[3].Value = model.p_InterfaceName;
parameters[4].Value = model.p_InterfaceType;
parameters[5].Value = model.p_MerchantNumber;
parameters[6].Value = model.p_KeyType;
parameters[7].Value = model.p_PrivateKey;
parameters[8].Value = model.p_PublicKey;
parameters[9].Value = model.IsEnabled;
parameters[10].Value = model.p_auditor;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加代付通道
/// </summary>
/// <returns></returns>
public ActionResult PayForAnotherAdd()
{
int id = string.IsNullOrEmpty(Request["id"]) ? 0 : int.Parse(Request["id"]);
if (id > 0)
{
//查询一条数据
PayForAnotherMode = PayForAnotherBll.GetModel(id);
}
DataSet ds = PayChannelBll.GetList("");
PayCList = JMP.TOOL.MdlList.ToList <JMP.MDL.PayChannel>(ds.Tables[0]);
ViewBag.mode = PayForAnotherMode;
ViewBag.list = PayCList;
return(View());
}
public JsonResult PayForAnother_PayChannelAdd(JMP.MDL.PayForAnotherInfo mode)
{
object retJson = new { success = 0, msg = "操作失败" };
if (mode.p_Id > 0)
{
PayForAnotherMode = PayForAnotherBll.GetModel(mode.p_Id);
//拷贝
var moPayForAnother = PayForAnotherMode.Clone();
PayForAnotherMode.p_InterfaceName = mode.p_InterfaceName;
PayForAnotherMode.p_InterfaceType = mode.p_InterfaceType;
PayForAnotherMode.p_MerchantNumber = mode.p_MerchantNumber;
PayForAnotherMode.p_KeyType = mode.p_KeyType;
PayForAnotherMode.p_PrivateKey = mode.p_PrivateKey;
PayForAnotherMode.p_PublicKey = mode.p_PublicKey;
PayForAnotherMode.p_auditor = UserInfo.UserName;
PayForAnotherMode.p_auditortime = DateTime.Now;
if (PayForAnotherBll.Update(PayForAnotherMode))
{
Logger.ModifyLog("修改代付通道信息", moPayForAnother, PayForAnotherMode);
retJson = new { success = 1, msg = "操作成功" };
}
}
else
{
mode.p_append = UserInfo.UserName;
mode.p_appendtime = DateTime.Now;
mode.p_auditor = null;
mode.p_auditortime = null;
mode.IsEnabled = true;
int num = PayForAnotherBll.Add(mode);
if (num > 0)
{
Logger.CreateLog("添加代付通道信息", mode);
retJson = new { success = 1, msg = "操作成功" };
}
}
return(Json(retJson));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.PayForAnotherInfo GetModel(int p_Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select p_Id, p_auditortime, p_append, p_appendtime, p_InterfaceName, p_InterfaceType, p_MerchantNumber, p_KeyType, p_PrivateKey, p_PublicKey, IsEnabled, p_auditor ");
strSql.Append(" from PayForAnotherInfo ");
strSql.Append(" where p_Id=@p_Id");
SqlParameter[] parameters =
{
new SqlParameter("@p_Id", SqlDbType.Int, 4)
};
parameters[0].Value = p_Id;
JMP.MDL.PayForAnotherInfo model = new JMP.MDL.PayForAnotherInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["p_Id"].ToString() != "")
{
model.p_Id = int.Parse(ds.Tables[0].Rows[0]["p_Id"].ToString());
}
if (ds.Tables[0].Rows[0]["p_auditortime"].ToString() != "")
{
model.p_auditortime = DateTime.Parse(ds.Tables[0].Rows[0]["p_auditortime"].ToString());
}
model.p_append = ds.Tables[0].Rows[0]["p_append"].ToString();
if (ds.Tables[0].Rows[0]["p_appendtime"].ToString() != "")
{
model.p_appendtime = DateTime.Parse(ds.Tables[0].Rows[0]["p_appendtime"].ToString());
}
model.p_InterfaceName = ds.Tables[0].Rows[0]["p_InterfaceName"].ToString();
if (ds.Tables[0].Rows[0]["p_InterfaceType"].ToString() != "")
{
model.p_InterfaceType = int.Parse(ds.Tables[0].Rows[0]["p_InterfaceType"].ToString());
}
model.p_MerchantNumber = ds.Tables[0].Rows[0]["p_MerchantNumber"].ToString();
if (ds.Tables[0].Rows[0]["p_KeyType"].ToString() != "")
{
model.p_KeyType = int.Parse(ds.Tables[0].Rows[0]["p_KeyType"].ToString());
}
model.p_PrivateKey = ds.Tables[0].Rows[0]["p_PrivateKey"].ToString();
model.p_PublicKey = ds.Tables[0].Rows[0]["p_PublicKey"].ToString();
if (ds.Tables[0].Rows[0]["IsEnabled"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsEnabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsEnabled"].ToString().ToLower() == "true"))
{
model.IsEnabled = true;
}
else
{
model.IsEnabled = false;
}
}
model.p_auditor = ds.Tables[0].Rows[0]["p_auditor"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.PayForAnotherInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.PayForAnotherInfo model)
{
return(dal.Add(model));
}
