public FrmRptPatientInfo()
{
InitializeComponent();
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
}
public ActionResult Index(int page = 1)
{
var db = new PetaPoco.Database("MonoCMS");
var categories = db.Fetch<Category>("SELECT category_name FROM category");
return View(categories);
//return View();
}
private void InitializeDatabase()
{
_db = new Database(_connectionStringName);
_db.EnableAutoSelect = false;
_db.EnableNamedParams = false;
_db.ForceDateTimesToUtc = false;
}
public FrmNewCaseHis(bool isAdd, Int64 base_id, Int64 reg_id)
{
InitializeComponent();
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
_reg_id = reg_id;
_isAdd = isAdd;
_baseID = base_id;
//ConditionValidationRule ruleNoEmpty = new ConditionValidationRule();
//ruleNoEmpty.ConditionOperator = ConditionOperator.IsNotBlank;
//ruleNoEmpty.ErrorText = "该项不能为空。";
//dxValidationProvider1.SetValidationRule(MEMOMemoEdit, ruleNoEmpty);
//dxValidationProvider1.SetValidationRule(DOSE_MEMOMemoEdit, ruleNoEmpty);
caseHis.REG_ID = _reg_id;
caseHis.BASE_INFO_ID = _baseID;
caseHis.OPERATOR = ClsFrmMng.WorkerID;
cASEHISTORYBindingSource.DataSource = caseHis;
lookUpEdit1.Properties.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", new object[] { 11 });
lookUpEdit1.Properties.DisplayMember = "DSP_MEMBER";
lookUpEdit1.Properties.ValueMember = "VALUE_MEMBER";
vALUECODEBindingSource.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", new object[] { 181 });
}
private void ProcessStats(IList<FeatureStatistics> stats)
{
try
{
Logger.Debug("Adding Stats to database");
using (var database = new PetaPoco.Database(_connectionStringName))
{
using (ITransaction transaction = database.GetTransaction())
{
foreach (var stat in stats)
{
foreach (var reading in stat.Readings)
{
var data = new FeatureData()
{
Reading = reading.Name,
Timestamp = DateTime.Now,
Name = stat.Name,
Group = stat.Group
};
data.ValueType = reading.GetType().Name;
SetValue(data, reading);
database.Insert("FeatureData", "Id", true, data);
}
}
transaction.Complete();
}
}
}
catch (Exception ex)
{
Logger.Error("Error saving stats to the database", ex);
}
}
public FrmDefaultDocAdvice_Cfg()
{
InitializeComponent();
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
}
private static List<Comment> GetAllComments()
{
using (var db = new Database("umbracoDbDSN"))
{
return db.Fetch<Comment>("SELECT * FROM forumComments WHERE isSpam = 1 ORDER BY id DESC");
}
}
public DBPetapocoComparer(DbObject dbAssert, DbObject dbTarget)
{
_dbAssert = new Database(string.Format("Data Source={0};Version=3;Read Only=True;", dbAssert.Value),
new SQLiteFactory());
_dbTarget = new Database(string.Format("Data Source={0};Version=3;Read Only=True;", dbTarget.Value),
new SQLiteFactory());
}
//[RequireBasicAuthentication("AppHarbor")]
public ActionResult Create(ProvisioningRequest provisionRequest)
{
if (provisionRequest == null || string.IsNullOrEmpty(provisionRequest.plan)) provisionRequest = new ProvisioningRequest() { callback_url = "/Response", heroku_id = Guid.NewGuid().ToString(), plan = "Free" };
var db = new Database("DefaultConnection");
Plan plan;
if (!Enum.TryParse<Plan>(provisionRequest.plan, true, out plan))
{
throw new ArgumentException(string.Format("Plan \"{0}\" is not a valid plan", provisionRequest.plan));
}
var purchase = new Purchase()
{
CreatedBy = string.Format("{0};{1}", Request.GetForwardedHostAddress(), User.Identity.Name),
UniqueId = Guid.NewGuid().ToString(),
Plan = plan,
ProviderId = provisionRequest.heroku_id,
ProvisionStatus = ProvisionStatus.Provisioning,
ApiKey = Guid.NewGuid().ToString(),
ApiSecretKey = Guid.NewGuid().ToString()
};
// TODO: Provision the resource
purchase.ProvisionStatus = ProvisionStatus.Provisioned;
Purchase.Save(db, purchase);
var output = new
{
id = purchase.UniqueId,
config = new
{
CONFIG_ApiKey = purchase.ApiKey,
CONFIG_ApiSecretKey = purchase.ApiSecretKey
}
};
return Json(output, JsonRequestBehavior.AllowGet);
}
public void Delete(long id)
{
if (id <= 0)
{
return;
}
ApiAccessPolicy policy = new ApiAccessPolicy(typeof(MixERP.Net.Entities.Core.Account), "DELETE");
policy.Authorize();
if (!policy.IsAuthorized)
{
throw new HttpResponseException(HttpStatusCode.Forbidden);
}
try
{
using (Database db = new Database(Factory.GetConnectionString(), "Npgsql"))
{
db.Delete("core.accounts", "account_id", null, id);
}
}
catch
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
public bool DeleteABSAMember(BSAMemberViewModel item)
{
//Connect to the Umbraco DB
var db = new PetaPoco.Database(sConnectString);
BSAMember oModel = new BSAMember();
oModel.BSAMemberId = item.BSAMemberId;
oModel.BSAMemberType = item.BSAMemberType;
oModel.FirstName = item.FirstName;
oModel.LastName = item.LastName;
oModel.StreetAddress = item.StreetAddress;
oModel.City = item.City;
oModel.State = item.State;
oModel.ZipCode = item.ZipCode;
oModel.District = item.District;
oModel.Council = item.Council;
oModel.Troop = item.Troop;
oModel.Crew = item.Crew;
oModel.Telephone = item.Telephone;
oModel.BirthDate = item.BirthDate;
oModel.EmailAddress = item.EmailAddress;
oModel.ScoutMasterId = item.ScoutMasterId;
oModel.BackGroundCheck = item.BackGroundCheck;
oModel.DeleteRecordFlag = true;
db.Update(oModel);
//Return the view with our model and comments
return(true);
}
public FrmNewPatientBaseInfo()
{
InitializeComponent();
////string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
ConditionValidationRule ruleNoEmpty = new ConditionValidationRule();
ruleNoEmpty.ConditionOperator = ConditionOperator.IsNotBlank;
ruleNoEmpty.ErrorText = "该项不能为空。";
dxValidationProvider1.SetValidationRule(NAMETextEdit, ruleNoEmpty);
dxValidationProvider1.SetValidationRule(ID_CODETextEdit, ruleNoEmpty);
pATIENTBASEINFOBindingSource.DataSource = patientBase;
MEDICARE_TYPETextEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("select DSP_MEMBER, VALUE_MEMBER from VALUE_CODE where GROUPNAME = @0", new object[] { 10 });
MEDICARE_TYPETextEdit.Properties.DisplayMember = "DSP_MEMBER";
MEDICARE_TYPETextEdit.Properties.ValueMember = "VALUE_MEMBER";
EDUCATIONAL_LEVELTextEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", new object[] { 8 });
EDUCATIONAL_LEVELTextEdit.Properties.DisplayMember = "DSP_MEMBER";
EDUCATIONAL_LEVELTextEdit.Properties.ValueMember = "VALUE_MEMBER";
MARITAL_STATUSTextEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", new object[] { 9 });
MARITAL_STATUSTextEdit.Properties.DisplayMember = "DSP_MEMBER";
MARITAL_STATUSTextEdit.Properties.ValueMember = "VALUE_MEMBER";
vALUECODEBindingSource.DataSource = db.Fetch<VALUE_CODE>("where groupname = 42");
vALUECODEBindingSource1.DataSource = db.Fetch<VALUE_CODE>("where groupname = 41");
vALUECODEBindingSource2.DataSource = db.Fetch<VALUE_CODE>("where groupname = 62");
vALUECODEBindingSource3.DataSource = db.Fetch<VALUE_CODE>("where groupname = 63");
}
public List <WorkOrder> GetWorkOrdersWithProduct()
{
using (var db = new PetaPoco.Database("AdventureWorks2014"))
{
return(GetWorkOrdersWithProduct(db));
}
}
public ActionResult GetLeases()
{
var db = new PetaPoco.Database("umbracoDbDSN");
var listOfLeases = db.Fetch<Lease>(new Sql().Select("*").From("_sg_Lease"));
return Json(listOfLeases);
}
public static List<Route> getRoutes()
{
using (Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes")))
{
return db.Fetch<Route>("WHERE deleted = FALSE");
}
}
public FrmNewRegist()
{
InitializeComponent();
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
//db.OpenSharedConnection();
lstOutpatientCategory = db.Fetch<OUTPATIENT_CATEGORY>("");
OUTPATIENT_CATEGORYTextEdit.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
OUTPATIENT_CATEGORYTextEdit.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("CATEGORY_ID"));
OUTPATIENT_CATEGORYTextEdit.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("CATEGORY_NAME"));
OUTPATIENT_CATEGORYTextEdit.Properties.DataSource = lstOutpatientCategory;
OUTPATIENT_CATEGORYTextEdit.Properties.ValueMember = "CATEGORY_ID"; // 对应ID
OUTPATIENT_CATEGORYTextEdit.Properties.DisplayMember = "CATEGORY_NAME"; // 显示内容
patientReg.STATUS = 0;
patientReg.OPERATOR = ClsFrmMng.WorkerID;
pATIENTREGISTBindingSource.DataSource = patientReg;
//db.CloseSharedConnection();
ConditionValidationRule ruleNoEmpty = new ConditionValidationRule();
ruleNoEmpty.ConditionOperator = ConditionOperator.IsNotBlank;
ruleNoEmpty.ErrorText = "该项不能为空。";
dxValidationProvider1.SetValidationRule(NAMETextEdit, ruleNoEmpty);
dxValidationProvider1.SetValidationRule(OUTPATIENT_CATEGORYTextEdit, ruleNoEmpty);
pATIENTBASEINFOBindingSource.DataSource = db.Fetch<PATIENT_BASEINFO>("");
NAMETextEdit.Properties.EditValueChanged += Properties_EditValueChanged;
}
public void CreateTables()
{
using (var db = new Database("DataSource=\"test.sdf\"; Password=\"chrissiespassword\"", "System.Data.SqlServerCe.4.0")) {
db.Execute("CREATE TABLE Person (Id int IDENTITY(1,1) PRIMARY KEY, LastName nvarchar (40) NOT NULL, FirstName nvarchar (40), AddressId int NOT NULL);");
db.Execute("CREATE TABLE Address (Id int IDENTITY(1,1) PRIMARY KEY, Street nvarchar (40) NOT NULL, HouseNumber nvarchar (10));");
}
}
public FrmQueryCheckInfo(string strPatName, decimal id)
{
InitializeComponent();
_strPatName = strPatName;
_id = id;
exdb = new Database("XE");
}
public static void UpdateCampaign(Campaign campaign)
{
using (IDatabase db = new PetaPoco.Database(Settings.ConnectionString, providerName: "SqlServer"))
{
db.Update(campaign);
}
}
private void GetItem(string SuppBatchGuid)
{
List<V_ERP_SuppOrder> items = null;
using (var db = new Database(SQLCONN.Conn))
{
if (!string.IsNullOrEmpty(UserName) && UserName != "admin")
{
items = db.Fetch<V_ERP_SuppOrder>("select * from V_ERP_SuppOrder where SuppBatchGuid=@0 and SuppName =@1", SuppBatchGuid, UserName);
}
else
{
items = db.Fetch<V_ERP_SuppOrder>("select * from V_ERP_SuppOrder where SuppBatchGuid=@0", SuppBatchGuid);
}
items.ForEach(j =>
{
j.Reserved2 = KyGYS.Controls.CommonUtil.GetItemImgFileName(j.Reserved2);
j.CusSavedFileName = j.CusSavedFileName!=null?KyGYS.Controls.CommonUtil.GetItemImgFileName(j.CusSavedFileName):null;
j.CtmSavedFileName = j.CtmSavedFileName != null ? KyGYS.Controls.CommonUtil.GetItemImgFileName(j.CtmSavedFileName) : null;
});
var grd = new EasyGridData<V_ERP_SuppOrder>();
grd.total = items.Count().ToString();
grd.rows = items;
string data = Newtonsoft.Json.JsonConvert.SerializeObject(grd);
Response.Write(data);
Response.End();
}
}
public static void deleteRoute(int id)
{
using (Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes")))
{
db.Execute("UPDATE route SET deleted = TRUE WHERE id = @0", id);
}
}
public FrmNewInduce(Int64 base_id, Int64 reg_id)
{
InitializeComponent();
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
_reg_id = reg_id;
_baseID = base_id;
//ConditionValidationRule ruleNoEmpty = new ConditionValidationRule();
//ruleNoEmpty.ConditionOperator = ConditionOperator.IsNotBlank;
//ruleNoEmpty.ErrorText = "该项不能为空。";
//dxValidationProvider1.SetValidationRule(MEMOMemoEdit, ruleNoEmpty);
//dxValidationProvider1.SetValidationRule(DOSE_MEMOMemoEdit, ruleNoEmpty);
induceMent.REG_ID = _reg_id;
induceMent.BASE_INFO_ID = _baseID;
induceMent.OPERATOR = ClsFrmMng.WorkerID;
iNDUCEMENTHISTORYBindingSource.DataSource = induceMent;
//INDUCEMENTTextEdit.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
INDUCEMENTTextEdit.Properties.DataSource = ClsFrmMng.lstIndecumentCode;
INDUCEMENTTextEdit.Properties.DisplayMember = "INDUCEMENT_MEMO";
INDUCEMENTTextEdit.Properties.ValueMember = "INDUCEMENT_MEMO";
}
/// <summary>
///
/// </summary>
/// <param name="base_id"></param>
/// <param name="reg_id"></param>
/// <param name="isTemp">0:长期, 1:临时</param>
public FrmNewDav(Int64 base_id, Int64 reg_id, int isTemp)
{
InitializeComponent();
if (isTemp == 0)
this.Text = "新建长期医嘱";
else
this.Text = "新建临时医嘱";
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
_regID = reg_id;
_baseID = base_id;
_isTemp = isTemp;
docAdv.REG_ID = _regID;
docAdv.BASE_INFO_ID = _baseID;
docAdv.OPERATOR = ClsFrmMng.WorkerID;
docAdv.ADVICE_TYPE = _isTemp;
docAdv.IS_DEL = 0;
dOCADVICEBindingSource.DataSource = docAdv;
vALUECODEBindingSource.DataSource = db.Fetch<VALUE_CODE>("");
M_UNITLookUpEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", new object[] { 14 });
M_UNITLookUpEdit.Properties.DisplayMember = "DSP_MEMBER";
M_UNITLookUpEdit.Properties.ValueMember = "VALUE_MEMBER";
M_ACTIONLookUpEdit.Properties.DataSource = db.Fetch<VALUE_CODE>("where GROUPNAME = @0", new object[] { 13 });
M_ACTIONLookUpEdit.Properties.DisplayMember = "DSP_MEMBER";
M_ACTIONLookUpEdit.Properties.ValueMember = "VALUE_MEMBER";
}
public static Route getRoute(int id)
{
using (Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes")))
{
return db.FirstOrDefault<Route>("WHERE id = @0", id);
}
}
public static Campaign GetById(int id)
{
using (IDatabase db = new PetaPoco.Database(Settings.ConnectionString, providerName: "SqlServer"))
{
return(db.Single <Campaign>("WHERE Id = @0", id));
}
}
void barBtnRefresh_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (var db = new Database()) {
this.gridControlEx1.DataSource = db.Fetch<t_role>("select * from t_role where IsUsing=1");
this.gridControlEx1.ReleaseFocusedRow();
}
}
public FrmBloodCleanup_Drugs()
{
InitializeComponent();
////string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
}
public Contato Find(int id)
{
Database db = new PetaPoco.Database("PRWDEV");
var contato = db.First <Contato>("Select * from contatosbandre where ID=@0", id);
return(contato);
}
public void SetPoints(int trackId, TrackPoint[] points)
{
var sb = new StringBuilder();
for (int i = 0; i < points.Length; i++)
{
if (i % 1000 == 0)
{
if(sb.Length>0) sb.Remove(sb.Length - 1, 1);
sb.AppendLine(";").AppendLine("insert into MR.tTrackPoint (TrackId, Idx, Lat, Lon, Elevation, PointTime) values ");
}
var p = points[i];
sb.AppendLine().Append("(")
.Append(trackId).Append(",")
.Append(i).Append(",")
.Append(p.Lat.ToString(CultureInfo.InvariantCulture)).Append(",")
.Append(p.Lon.ToString(CultureInfo.InvariantCulture)).Append(",")
.Append(p.Elevation.ToString(CultureInfo.InvariantCulture)).Append(",")
.Append("'").Append(p.PointTime.ToString("o",CultureInfo.InvariantCulture)).Append("'")
.Append("),");
}
var sql = sb.ToString().TrimEnd(',');
var db = new Database(_config.ConnectionString, "System.Data.SqlClient");
try
{
db.Execute(sql);
}
catch (SqlException ex)
{
throw new Exception(sql, ex);
}
}
private void btnOK_Click(object sender, EventArgs ea)
{
var k = roleGridEdit1.GetSelectedValue();
if (null == k) return;
List<MenuCtlData> lst = new List<MenuCtlData>(100);
foreach (TreeListNode td in treeCtl1.Nodes)
{
var mnugrp = td.GetValue(0).ToString();
foreach (TreeListNode tds in td.Nodes)
{
var mnuname = tds.GetValue(0).ToString();
foreach (TreeListNode tmd in tds.Nodes)
{
var mcd = tmd.Tag as MenuCtlData;
if (null != mcd)
{
mcd.IsEnabled = tmd.Checked;
mcd.MenuGrpName = mnugrp;
mcd.MenuName = mnuname;
lst.Add(mcd);
}
foreach (TreeListNode tkd in tmd.Nodes)
{
var md = tkd.Tag as MenuCtlData;
if (null == md) continue;
md.IsEnabled = tkd.Checked;
md.MenuGrpName = mnugrp; md.MenuName = mnuname;
lst.Add(md);
}
}
}
}
var usr = GetCurUser<t_user>();
using (var db = new Database())
{
var et = db.FirstOrDefault<t_roleset>("select * from t_roleset where RoleId=@0", k.Id);
var roleset = et;
if (et != null)
{
roleset.RoleSetTree = Ultra.Web.Core.Common.ObjectHelper.SerializeJson(lst);
}
else
{
roleset = new t_roleset
{
RoleSetTree = Ultra.Web.Core.Common.ObjectHelper.SerializeJson(lst),
RoleId = k.Id,
IsUsing = true,
RoleName = k.Name,
Guid = Guid.NewGuid(),
Creator =this.CurUser,
CreateDate = TimeSync.Default.CurrentSyncTime
};
}
db.Save(roleset);
}
MsgBox.ShowMessage(null, "保存成功!");
}
public static IEnumerable <Campaign> GetAll()
{
using (IDatabase db = new PetaPoco.Database(Settings.ConnectionString, providerName: "SqlServer"))
{
return(db.Query <Campaign>(Settings.CampaignsQuery));
}
}
private static List<Topic> GetAllTopics()
{
using (var db = new Database("umbracoDbDSN"))
{
return db.Fetch<Topic>("SELECT * FROM forumTopics WHERE isSpam = 1 ORDER BY id DESC");
}
}
//public static Payment recordPayment(Rider rider, double amount, string branch, string username, string account)
//{
// Payment payment = new Payment();
// payment.rider = rider.name;
// payment.amount = amount;
// payment.paid_date = DateTime.Now;
// payment.bank_branch = branch;
// payment.bank_username = username;
// payment.bank_account = account;
// Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes"));
// db.Insert(payment);
// return payment;
//}
//public static void deletePayment(int id)
//{
// Database db = new PetaPoco.Database("bikes-clunie");
// db.Execute("DELETE FROM payment WHERE id = @0", id);
//}
internal void save()
{
using (Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes")))
{
db.Save(this);
}
}
public FrmUserLogin()
{
InitializeComponent();
try
{
txtUserID.Text = ConfigurationManager.AppSettings["UserID"];
if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["ShowCommTestToolsLink"]))
{
try
{
linkLabel1.Visible = Convert.ToBoolean(ConfigurationManager.AppSettings["ShowCommTestToolsLink"]);
}
catch { }
}
}
catch { txtUserID.Text = ""; }
try
{
//string sPwd = Des.Decrypt(ClsFrmMng.KEY, ConfigurationManager.AppSettings["DbPwd"]);
db = new Database("XE");
}
catch (Exception err)
{
XtraMessageBox.Show(err.Message, "错误提示");
}
}
////utility function to build the sql statement to perform the join
//private static Sql sql()
//{
// return Sql
// .Builder
// .Append("SELECT a.id, a.bike_id, a.rider_id, a.route_id, a.ride_date, a.notes,")
// .Append("a.reward, a.distance, a.paid, a.payment_id,")
// .Append("b.name AS route, c.name AS rider, d.name AS bike")
// .Append("FROM ride a, route b, rider c, bike d")
// .Append("WHERE a.route_id = b.id AND a.rider_id = c.id AND a.bike_id = d.id");
//}
public static List<Ride> getRides()
{
using (Database db = new PetaPoco.Database(ModelConfig.connectionStringName("bikes")))
{
return db.Fetch<Ride>("");
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (!dxValidationProvider1.Validate())
return;
var odrs = gcOrder.GetDataSource<t_order>();
if (odrs == null || odrs.Count < 1) {
MsgBox.ShowMessage("提示", "没有添加商品不能保存!");
return;
}
if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.New) {
var trdnew = new t_trade() {
Guid = GuidKey,
ReceiverName = Trade.ReceiverName,
ReceiverMobile = Trade.ReceiverMobile,
ReceiverAddress = Trade.ReceiverAddress,
MemberGuid = Trade.Guid,
DeliveryDate = dateDeliveryDate.DateTime,
CreateDate = TimeSync.Default.CurrentSyncTime,
Creator = this.CurUser,
};
using (var db = new Database()) {
try {
db.BeginTransaction();
db.Save(trdnew);
odrs.ForEach(k => db.Save(k));
db.CompleteTransaction();
} catch (Exception) {
db.AbortTransaction();
throw;
}
}
} else if (EditMode == Ultra.Web.Core.Enums.EnViewEditMode.Edit) {
using (var db = new Database()) {
var trd = db.FirstOrDefault<t_trade>(" where guid=@0", GuidKey);
trd.ReceiverName = Trade.ReceiverName;
trd.ReceiverMobile = txtMobile.Text;
trd.ReceiverAddress = txtReceiverAddress.Text;
trd.MemberGuid = Trade.Guid;
trd.DeliveryDate = TimeSync.Default.CurrentSyncTime;
trd.DeliveryDate = dateDeliveryDate.DateTime;
try {
db.BeginTransaction();
db.Save(trd);
db.Execute("delete t_order where tradeguid=@0", trd.Guid);
odrs.ForEach(k => {
k.Id = 0;
db.Save(k);
});
db.CompleteTransaction();
} catch (Exception) {
db.AbortTransaction();
throw;
}
}
}
DialogResult = System.Windows.Forms.DialogResult.OK;
Close();
}
public ContactRepository(IOptions <ConnectionConfig> options, AutoMapper.IMapper mapper)
{
_mapper = mapper ?? throw new ArgumentNullException(nameof(mapper));
ConnecStr = options.Value.ConnectionStr;
Provider = options.Value.Priovder;
//Db = new PetaPoco.Database(ConnecStr, Provider, null);
Db = new PetaPoco.Database("server = .;database = ContactInformation;uid = sa; pwd = 123", "System.Data.SqlClient", null);
}
public List <Orders> GetOrders()
{
using (var db = new PetaPoco.Database("AdventureWorks2014"))
{
return(db.Query <Orders>(@"SELECT TOP 500 [WorkOrderID] AS Id, P.Name AS ProductName, [OrderQty] AS Quantity, [DueDate] AS Date
FROM [AdventureWorks2014].[Production].[WorkOrder] AS WO
INNER JOIN[Production].[Product] AS P ON P.ProductID = WO.ProductID").ToList());
}
}
protected void Button4_Click(object sender, EventArgs e)
{
var db = new PetaPoco.Database("myConnectionString");
string queryBooks = "SELECT * FROM Responses order by date_created desc";
var result = db.Query <pixResponses>(queryBooks);
// GridView1.DataSource = result;
// GridView1.DataBind();
}
static void Main(string[] args)
{
var db = new PetaPoco.Database(connectionString: "server=.;database=orderdb;uid=sa;pwd=1;", providerName: "sqlservers");
foreach (var order in db.Query <Orders>("select * from orders"))
{
Console.WriteLine(order);
}
}
public static List <PersonalProject> GetOrgProjects(string projectId, OrganizationType organizationType)
{
var db = new PetaPoco.Database("DefaultConnection");
var sql = new Sql(@"select op.*,o.OrganizationName,op.StudysiteNo, o.SubDomain from sms_orgProject op
left join cts_organization o on op.organizationId=o.id
where op.projectid=@0 and o.OrganizationType=@1 and isnull(op.isdeleted,0)<>1 and isnull(o.isdeleted,0)<>1", projectId, organizationType);
return(db.Fetch <PersonalProject>(sql));
}
/// <summary>
/// Fetches the complete set of elements and returns this set as an IEnumerable.
/// </summary>
/// <returns>the set fetched</returns>
public override IEnumerable <SalesOrderHeader> FetchSet()
{
var headers = new List <SalesOrderHeader>();
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
headers = dbFactory.Fetch <SalesOrderHeader>(CommandText);
dbFactory.CloseSharedConnection();
return(headers);
}
public string getAllMarkers()
{
using (var db = new PetaPoco.Database("linkSTEM"))
{
var SQL = Sql.Builder.Append("SELECT *")
.Append("FROM [dbo].[Markers]");
return(JsonConvert.SerializeObject(db.Fetch <Marker>(SQL)));
}
}
/// <summary>
/// 查询所有参与这个项目的项目信息--返回SQL字符串
/// </summary>
/// <param name="projectId"></param>
/// <returns></returns>
public static string GetOrgProjectsString(string projectId, OrganizationType organizationType)
{
var db = new PetaPoco.Database("DefaultConnection");
var sql = @"select op.Id from sms_orgProject op
left join cts_organization o on op.organizationId=o.id
where op.projectid='{0}' and o.OrganizationType={1} and isnull(op.isdeleted,0)<>1 and isnull(o.isdeleted,0)<>1";
var sss = string.Format(sql, projectId, (int)organizationType);
return(string.Format(sql, projectId, (int)organizationType));
}
private BSAMemberViewModel GetABSAMemberInternal(int iID)
{
//Connect to the Umbraco DB
var db = new PetaPoco.Database(sConnectString);
//Get an IENumberable of MeritBadges objects to iterate over
var item = db.Single <BSAMember>(iID);
return(FillViewModelBSAMember(item, true));
}
public string getProvider(string username, string password)
{
using (var db = new PetaPoco.Database("linkSTEM"))
{
var SQL = Sql.Builder.Append("SELECT *")
.Append("FROM [dbo].[Providers]")
.Append("WHERE [provider_Username] = @0 AND [provider_Password] = @1", username, password);
return(JsonConvert.SerializeObject(db.FirstOrDefault <Provider>(SQL)));
}
}
/// <summary>
/// Fetches the individual element
/// </summary>
/// <param name="key">The key of the element to fetch.</param>
/// <returns>The fetched element, or null if not found</returns>
public override SalesOrderHeader FetchIndividual(int key)
{
SalesOrderHeader toReturn = null;
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
toReturn = dbFactory.First <SalesOrderHeader>(CommandText + " where SalesOrderId=@0", key);
dbFactory.CloseSharedConnection();
return(toReturn);
}
public string getProviderMarkers(int providerID)
{
using (var db = new PetaPoco.Database("linkSTEM"))
{
var SQL = Sql.Builder.Append("SELECT *")
.Append("FROM [dbo].[Markers]")
.Append("WHERE [provider_ID] = @0", providerID);
return(JsonConvert.SerializeObject(db.Fetch <Marker>(SQL)));
}
}
private void ShowSpeciesListView(PetaPoco.Database database)
{
View.SpeciesListView speciesListView = new View.SpeciesListView();
ViewModel.SpeciesListViewModel speciesListViewModel = new ViewModel.SpeciesListViewModel(this);
speciesListView.DataContext = speciesListViewModel;
speciesListViewModel.Load();
speciesListView.WindowStartupLocation = WindowStartupLocation.CenterOwner;
speciesListView.Owner = this;
speciesListView.ShowDialog();
speciesListView._datagrid.Columns[0].Visibility = Visibility.Collapsed;
}
public static void Xoa(string id, sanpham sp)
{
var db = new PetaPoco.Database("DienThoaiShopConnection");
//db.Delete<sanpham>("where MaSanPham=@0", id);
sp = ChiTietSanPham(id);
sp.BiXoa = 1;
db.Update("sanpham", "MaSanPham", sp);
//var a = new sanpham();
//var db = new PetaPoco.Database("DienThoaiShopConnection");
//db.Delete("sanpham", "MaSanPham", null, a);
}
public ActionResult Index()
{
var db = new PetaPoco.Database("DefaultConnection");
//var sql1 = new Sql("CREATE TABLE #tb1(Id varchar(50) not null)");
//db.Execute(sql1);
var sql2 = new Sql(@"select op.*,o.OrganizationName,op.StudysiteNo, o.SubDomain from sms_orgProject op
left join cts_organization o on op.organizationId=o.id
where op.projectid =@0 and o.OrganizationType=@1 and isnull(op.isdeleted,0)<>1 and isnull(o.isdeleted,0)<>1", "593169721116912623", 2);
var kk = db.Fetch <PersonalProject>(sql2);
var ssj = db.LastArgs;
var ks = db.LastCommand;
var s = db.LastSQL;
var k12 = GetOrgProjects("593079586929400170", OrganizationType.StudySite);
var k2 = GetOrgProjectsString("593079586929400170", OrganizationType.StudySite);
//(!input.isSiteDataCollection && input.SubjectVisitIds != null&& input.SubjectVisitIdsString == null ? " and #subjectVisit.Id in " + string.Format("('{0}')", string.Join("','", input.SubjectVisitIds)) : (!input.isSiteDataCollection && input.SubjectVisitIds != null ? " and #subjectVisit.Id in " + string.Format("({0})", string.Join("','", input.SubjectVisitIds)) : ""))
//(!input.isSiteDataCollection && input.SubjectVisitIds != null ? " and #subjectVisit.Id in " + string.Format("('{0}')", string.Join("','", input.SubjectVisitIds)) : "")
// // Create the article
// var a = new test();
// a.name = "我的标题";
// a.type = 4;
// db.Insert("test", "id", a);
// var result = db.Page<test>(1, 2, // <-- page number and items per page
//"SELECT * FROM test WHERE type=@0 ORDER BY id DESC", 3);
// var ssd = db.Query<test>("SELECT * FROM test");
// // 查询所有数据
// foreach (var aaa in db.Query<test>("SELECT * FROM test"))
// {
// //var ss = aa;
// Response.Write(aaa.name);
// //Console.WriteLine("{0} - {1}", a.article_id, a.title);
// }
// //查询标量
// long count = db.ExecuteScalar<long>("SELECT Count(*) FROM test");
// Response.Write(count);
// //查询单条数据
// var aa = db.SingleOrDefault<test>("SELECT * FROM test WHERE id=@0", 1);
// Response.Write(aa.name);
return(View());
}
/// <summary>
/// Fetches the complete set of elements and returns this set as an IEnumerable.
/// </summary>
/// <returns>the set fetched</returns>
public override IEnumerable <SalesOrderHeader> FetchSet()
{
var headers = new List <SalesOrderHeader>();
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
dbFactory.EnableAutoSelect = false;
dbFactory.EnableNamedParams = false;
dbFactory.ForceDateTimesToUtc = false;
headers = dbFactory.Fetch <SalesOrderHeader>(CommandText);
dbFactory.CloseSharedConnection();
return(headers);
}
/// <summary>
/// Fetches the individual element
/// </summary>
/// <param name="key">The key of the element to fetch.</param>
/// <returns>The fetched element, or null if not found</returns>
public override SalesOrderHeader FetchIndividual(int key)
{
SalesOrderHeader toReturn = null;
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
dbFactory.EnableAutoSelect = false;
dbFactory.EnableNamedParams = false;
dbFactory.ForceDateTimesToUtc = false;
toReturn = dbFactory.First <SalesOrderHeader>(CommandText + " where SalesOrderId=@0 ", key);
dbFactory.CloseSharedConnection();
return(toReturn);
}
public IList <Contato> PesquisaAll(string query)
{
Database db = new PetaPoco.Database("PRWDEV");
if (query == null)
{
return(db.Fetch <Contato>("Select * FROM contatosbandre"));
}
else
{
return(db.Fetch <Contato>("Select * FROM contatosbandre WHERE nome like '%' + @query + '%' or cpf like '%' + @query + '%' or estadoid = @query", new { query }));
}
}
public List <User> GetUsers()
{
// TODO: Need to make it generic
var dbConnectionString = appSettings.Value.DefaultConnection;
NpgsqlConnection conn = new NpgsqlConnection(dbConnectionString.ToString());
conn.Open();
PetaPoco.Database db = new PetaPoco.Database(conn);
List <User> userslst = db.Query <User>(strGetUsersQuery).ToList();
conn.Close();
return(userslst);
}
private static void ExecuteSQL(string sql, PetaPoco.Database db = null)
{
if (db == null)
{
using (db = new Database(Environments.Current.Connection, "System.Data.SqlClient"))
{
db.Execute(sql);
}
}
else
{
db.Execute(sql);
}
}
public List <Orders> GetOrders(int iteration)
{
var listOrders = new List <Orders>();
using (var db = new PetaPoco.Database("AdventureWorks2014"))
{
for (int i = 1; i <= iteration; i++)
{
listOrders.Add(GetOrder(db, i));
}
}
return(listOrders);
}
/// <summary>
/// 获取员工信息集合(简要信息)
/// 区别：这是简要的员工信息，用来做任务分配
/// </summary>
/// <param name="LoginGuid">登入者GUID</param>
/// <returns></returns>
public List <MEmployee> GetEmployeeList(string LoginGuid)
{
List <MEmployee> employees;
using (SqlConnection sqlConnection = new SqlConnection(SystemSqlConn))
{
sqlConnection.Open();
using (Database db = new PetaPoco.Database(sqlConnection))
{
employees = db.Fetch <MEmployee>(@"SELECT EmployeeGuid,EmployeeCode,EmployeeNickName,EmployeeSex,EmployeeTel,TelOperator FROM Tb_Employee WHERE BelongToUser = @0 AND EmployeeIsLocked = 0", LoginGuid);
}
return(employees);
}
}
public bool addProvider(Provider provider)
{
try
{
using (var db = new PetaPoco.Database("linkSTEM"))
{
db.Insert("Providers", "provider_ID", provider);
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public IHttpActionResult GetStory(string id)
{
var db = new PetaPoco.Database("AGSoftware");
Entities.Storytime storytime = db.SingleOrDefault <Entities.Storytime>("Select * From StoryTime Where StorytimeId = @0", id);
if (storytime != null)
{
return(Ok(storytime));
}
else
{
return(NotFound());
}
}
