/// <summary>
/// 保存时获取产品主键
/// </summary>
/// <param name="entities"></param>
/// <returns></returns>
public SavedResult <Int64> Save2(IList <QTProductUserModel> entities)
{
SavedResult <Int64> savedresult = new SavedResult <Int64>();
try
{
for (var i = 0; i < entities.Count; i++)
{
if (entities[i].ProductBZ != "")
{
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("ProductBZ", entities[i].ProductBZ));
QTProductModel qTProductModel = QTProductFacade.Find(dic).Data[0];
entities[i].ProductPhid = qTProductModel.PhId;
}
}
savedresult = base.Save <Int64>(entities, "");
}
catch (Exception ex)
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = ex.Message.ToString();
}
return(savedresult);
}
/// <summary>
/// 获取产品用户通过产品标识和G6账号
/// </summary>
/// <param name="ProductBZ"></param>
/// <param name="UserNo"></param>
/// <returns></returns>
public QTProductUserModel getUserByProduct(string ProductBZ, string UserNo)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ))
.Add(ORMRestrictions <string> .Eq("Fg3userno", UserNo));
var Dygx = QTProductUserDygxFacade.Find(dic).Data;
if (Dygx.Count > 0)
{
Dictionary <string, object> dic2 = new Dictionary <string, object>();
new CreateCriteria(dic2).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ))
.Add(ORMRestrictions <string> .Eq("ProductUserCode", Dygx[0].ProductUserCode));
var ProductUser = base.Find(dic2).Data;
if (ProductUser.Count > 0)
{
Dictionary <string, object> dic3 = new Dictionary <string, object>();
new CreateCriteria(dic3).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ));
IList <QTProductModel> qTProductModelList = QTProductFacade.Find(dic3).Data;
if (qTProductModelList.Count > 0)
{
QTProductModel qTProductModel = qTProductModelList[0];
string conn;
string sqltext = "SELECT " + qTProductModel.FSqlUserTablePwd + " FROM " + qTProductModel.FSqlUserTable + " WHERE " + qTProductModel.FSqlUserTableCode + "='" + ProductUser[0].ProductUserCode + "'";
if (qTProductModel.FSqlType == "oracle")
{
conn = "ConnectType=ORACLEClient;Data Source=" + qTProductModel.FSqlServer + ";User ID=" + qTProductModel.FSqlDataName + ";Password="******";";
}
else
{
conn = "ConnectType=SqlClient;Server=" + qTProductModel.FSqlServer + ";Database=" + qTProductModel.FSqlSource + ";User ID =" + qTProductModel.FSqlDataName + "; Password="******";";
}
DbHelper.Open(conn);
DataTable dataTable = DbHelper.GetDataTable(conn, sqltext);
DbHelper.Close(conn);
if (dataTable.Rows.Count > 0)
{
ProductUser[0].ProductUserPwd = dataTable.Rows[0][qTProductModel.FSqlUserTablePwd].ToString();
}
}
return(ProductUser[0]);
}
else
{
return(null);
}
}
else
{
return(null);
}
}