public ProType Update(ProType obj) { ProTypeBO protypeBO = new ProTypeBO(obj); protypeDao.Update(protypeBO); return(obj); }
private void Color_button1_Click(object sender, EventArgs e) { ColorDialog colorDia = new ColorDialog(); if (colorDia.ShowDialog() == DialogResult.OK) { //获取所选择的颜色 Color colorChoosed = colorDia.Color; var DiyR = colorChoosed.R.ToString(); var DiyG = colorChoosed.G.ToString(); var DiyB = colorChoosed.B.ToString(); var DiyA = colorChoosed.A.ToString(); // MessageBoxButtons messButton = MessageBoxButtons.OKCancel; // DialogResult dr = MessageBox.Show(DiyR + "," + DiyG + "," + DiyB + "," + DiyA); R.Text = DiyR; G.Text = DiyG; B.Text = DiyB; A.Text = DiyA; var Proinstance = nodeGraph2.Nodes[Member]; if (ProType.Equals("ADD")) { } else { (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.R = colorChoosed.R; (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.G = colorChoosed.G; (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.B = colorChoosed.B; (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.A = colorChoosed.A; } } }
private void A_MouseMove(object sender, MouseEventArgs e) { if (Aispress) { Point point = A.PointToClient(Control.MousePosition); if ((point.X + tempA) < 0) { A.Text = "0"; } else if ((point.X + tempA) > 255) { A.Text = "255"; } else { A.Text = (point.X + tempA).ToString(); var Proinstance = nodeGraph2.Nodes[Member]; if (ProType.Equals("ADD")) { } else { (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.A = Convert.ToSingle(A.Text); } } } }
public async Task GenerateCode(ProType type, int durationDays, int useAmount, int codeAmount, string prefix, string id, int codeExpiresInDays, [Remainder] string str = "") { prefix = prefix == "0" ? null : prefix; id = id == "0" ? null : id; DateTime?expires = null; if (codeExpiresInDays != 0) { expires = DateTime.Now.AddDays(codeExpiresInDays); } var res = await PremiumCodeDb.GenerateCodes(type, durationDays, useAmount, codeAmount, prefix, id, expires); var example = res.FirstOrDefault(); string desc = "```yaml\n"; foreach (var prop in example.GetProperties()) { desc += prop.Key + ": " + prop.Value + "\n"; } desc += "```\n```yaml\n"; foreach (var code in res.Select(x => x.Id)) { desc += code + "\n"; } desc += "```"; await Context.Channel.SendMessageAsync(desc); }
public static string SelectField(string FieldName, ProType typ, DBManagement DBMan) { if (typ == ProType.VNDATESTRING) { switch (DBMan) { case DBManagement.Access: return string.Format("Format$({0},'dd/MM/yyyy') AS {0}", FieldName); default: return string.Format("Convert(varchar, {0}, 103) AS {0}", FieldName); } } else return FieldName; }
private void ScaleZ_MouseMove(object sender, MouseEventArgs e) { if (ScaleZispress) { Point point = ScaleZ.PointToClient(Control.MousePosition); ScaleZ.Text = (point.X + tempScaleZ).ToString(); var Proinstance = nodeGraph2.Nodes[Member]; if (ProType.Equals("ADD")) { } else { (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Z = Convert.ToSingle(ScaleZ.Text); } } }
private void RotationPitch_MouseMove(object sender, MouseEventArgs e) { if (RotationPitchispress) { Point point = RotationPitch.PointToClient(Control.MousePosition); RotationPitch.Text = (point.X + tempRotationPitch).ToString(); var Proinstance = nodeGraph2.Nodes[Member]; if (ProType.Equals("ADD")) { } else { (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Pitch = Convert.ToSingle(RotationPitch.Text); } } }
public static string IsDBNULL(object source, ProType typ, DBManagement DBMan) { if (source != null && !string.IsNullOrEmpty(source.ToString())) { if (typ == ProType.DATETIME || source is DateTime || source is DateTime?) { if (DBMan == DBManagement.Oracle) { return clsAll.Date2Oracle((DateTime)source); } else { return clsAll.Date2SQL((DateTime)source); } } else { switch (typ) { case ProType.STRING: if (DBMan == DBManagement.Access || DBMan == DBManagement.Oracle) return string.Format("'{0}'", source); else return string.Format("N'{0}'", source); case ProType.USDATESTRING: return clsAll.DateEN2SQL(source.ToString()); case ProType.VNDATESTRING: return clsAll.DateVN2SQL(source.ToString()); case ProType.BOOL: if (DBMan == DBManagement.Access) return clsAll.ConvertToBool(source.ToString()).ToString(); else return clsAll.ConvertToBit(source.ToString()).ToString(); default: if (!string.IsNullOrEmpty(source.ToString())) return string.Format("{0:0.###############}", source); else return "NULL"; } } } else { return "NULL"; } }
public static async Task <IEnumerable <PremiumCode> > GenerateCodes(ProType type, int durationDays, int useAmount, int codeAmount, string prefix = null, string id = null, DateTime?expiresAt = null) { if (codeAmount > 1 && id != null) { throw new NamikoException("Only 1 code can be made with a custom id. Use prefix instead."); } if (codeAmount < 1) { throw new NamikoException("Amount must be >0"); } if (durationDays < 1) { throw new NamikoException("DurationDays must be >0"); } using var db = new NamikoDbContext(); var codes = new List <PremiumCode>(); for (int i = 0; i < codeAmount; i++) { var code = id ?? prefix ?? ""; if (id == null) { code += RandomString(8); } var item = new PremiumCode { CreatedAt = DateTime.Now, ExpiresAt = expiresAt, DurationDays = durationDays, Type = type, UsesLeft = useAmount, Id = code }; codes.Add(item); } db.PremiumCodes.AddRange(codes); var res = await db.SaveChangesAsync(); return(codes); }
public static object ToDBParam(object source, ProType typ, DBManagement DBMan) { if (source != null && !string.IsNullOrEmpty(source.ToString())) { //TuyenHM su dung parameter nen ko can convert nua //if (typ == ProType.DATETIME || source is DateTime || source is DateTime?) //{ // return clsAll.Date2SQL((DateTime)source); //} //else //{ switch (typ) { case ProType.STRING: return source; case ProType.USDATESTRING: DateTime? dtUS = clsAll.StringUSToDate(source.ToString()); if (dtUS == null) return DBNull.Value; else return dtUS; case ProType.VNDATESTRING: DateTime? dtVN = clsAll.StringVNToDate(source.ToString()); if (dtVN == null) return DBNull.Value; else return dtVN; case ProType.DATETIME: return (DateTime)source; case ProType.BOOL: if (DBMan == DBManagement.Access) return clsAll.ConvertToBool(source.ToString()); else return clsAll.ConvertToBit(source.ToString()); case ProType.NUMBER: //TuyenHM //return string.Format("{0:0.###############}", source); return source; default: return source; } //} } else { return DBNull.Value; } }
public static object ToDBParam(object source, ProType typ) { return ToDBParam(source, typ, defaultDBMan); }
public static string SelectField(string FieldName, ProType typ) { return SelectField(FieldName, typ, defaultDBMan); }
public static string IsDBNULL(object source, ProType typ) { return IsDBNULL(source, typ, defaultDBMan); }
public int Insert(ProType obj) { ProTypeBO protypeBO = new ProTypeBO(obj); return(protypeDao.Insert(protypeBO)); }
//添加 private void Confirm_Edit(object sender, EventArgs e) { var ProName = PropertiseName.Text; var Proinstance = nodeGraph2.Nodes[Member]; var ZDProType = nodeGraph2.Nodes[Member].Properties[EditedPropertise].DependencyObjectType.Name; var properitem = (Member + "," + EditedPropertise + "," + ChoosedPropertise.Text).ToString(); if (ProType.Equals("ADD")) { switch (ZDProType) { case "ZDProperty_String": if (EditedPropertise.Equals("NodeName")) { MessageBoxButtons messButton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("不可修改NodeName,若要修改请联系管理员", "退出", messButton); if (dr == DialogResult.OK) //如果点击“确定”按钮 { this.Close(); } else //如果点击“取消”按钮 { this.Close(); } } else { // (Proinstance.Properties[EditedPropertise] as ZDProperty_String).Value = ChoosedPropertise.Text; setFormTextValue(properitem); //temp.FinalList.Items.Add(properitem); } this.Close(); break; case "ZDProperty_Float": // (Proinstance.Properties[EditedPropertise] as ZDProperty_Float).Value = Convert.ToSingle(ChoosedPropertise.Text); setFormTextValue(properitem); this.Close(); break; case "ZDProperty_Boolean": var tbool = false; if (BooleanStatus.Text.Equals("true")) { tbool = true; } // (Proinstance.Properties[EditedPropertise] as ZDProperty_Boolean).Value = tbool; var Boolproperitem = (Member + "," + EditedPropertise + "," + tbool).ToString(); setFormTextValue(Boolproperitem); this.Close(); break; case "ZDProperty_Integer": // (Proinstance.Properties[EditedPropertise] as ZDProperty_Integer).Value = Convert.ToInt32(ChoosedPropertise.Text); this.Close(); setFormTextValue(properitem); break; case "ZDProperty_Transform": /* (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.X = Convert.ToSingle(LocationX.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.Y = Convert.ToSingle(LocationY.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.Z = Convert.ToSingle(LocationZ.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Roll = Convert.ToSingle(RotationRoll.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Yaw = Convert.ToSingle(RotationYaw.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Pitch = Convert.ToSingle(RotationPitch.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.X = Convert.ToSingle(ScaleX.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Y = Convert.ToSingle(ScaleY.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Z = Convert.ToSingle(ScaleZ.Text);*/ var Transproperitem = (Member + "," + EditedPropertise + "," + LocationX.Text + "," + LocationY.Text + "," + LocationZ.Text + "," + RotationRoll.Text + "," + RotationYaw.Text + "," + RotationPitch.Text + "," + ScaleX.Text + "," + ScaleY.Text + "," + ScaleZ.Text).ToString(); setFormTextValue(Transproperitem); this.Close(); break; case "ZDProperty_Color": /* (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.R = Convert.ToSingle(R.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.G = Convert.ToSingle(G.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.B = Convert.ToSingle(B.Text); * (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.A = Convert.ToSingle(A.Text);*/ var Colorproperitem = (Member + "," + EditedPropertise + "," + R.Text + "," + G.Text + "," + B.Text + "," + A.Text).ToString(); setFormTextValue(Colorproperitem); this.Close(); break; default: break; } } if (ProType.Equals("PREVIEW")) { switch (ZDProType) { case "ZDProperty_String": if (EditedPropertise.Equals("NodeName")) { MessageBoxButtons messButton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("不可修改NodeName,若要修改请联系管理员", "退出", messButton); if (dr == DialogResult.OK) //如果点击“确定”按钮 { this.Close(); } else //如果点击“取消”按钮 { this.Close(); } } else { (Proinstance.Properties[EditedPropertise] as ZDProperty_String).Value = ChoosedPropertise.Text; // setFormTextValue(properitem); //temp.FinalList.Items.Add(properitem); } // this.Close(); break; case "ZDProperty_Float": (Proinstance.Properties[EditedPropertise] as ZDProperty_Float).Value = Convert.ToSingle(ChoosedPropertise.Text); // setFormTextValue(properitem); // this.Close(); break; case "ZDProperty_Boolean": var tbool = false; if (BooleanStatus.Text.Equals("true")) { tbool = true; } (Proinstance.Properties[EditedPropertise] as ZDProperty_Boolean).Value = tbool; // var Boolproperitem = (Member + "," + EditedPropertise + "," + tbool).ToString(); // setFormTextValue(Boolproperitem); // this.Close(); break; case "ZDProperty_Integer": (Proinstance.Properties[EditedPropertise] as ZDProperty_Integer).Value = Convert.ToInt32(ChoosedPropertise.Text); // this.Close(); // setFormTextValue(properitem); break; case "ZDProperty_Transform": (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.X = Convert.ToSingle(LocationX.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.Y = Convert.ToSingle(LocationY.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Location.Z = Convert.ToSingle(LocationZ.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Roll = Convert.ToSingle(RotationRoll.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Yaw = Convert.ToSingle(RotationYaw.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Rotation.Pitch = Convert.ToSingle(RotationPitch.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.X = Convert.ToSingle(ScaleX.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Y = Convert.ToSingle(ScaleY.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Transform).Value.Scale.Z = Convert.ToSingle(ScaleZ.Text); // var Transproperitem = (Member + "," + EditedPropertise + "," + LocationX.Text + "," + LocationY.Text + "," + LocationZ.Text + "," + RotationRoll.Text + "," + RotationYaw.Text + "," + RotationPitch.Text + "," + ScaleX.Text + "," + ScaleY.Text + "," + ScaleZ.Text).ToString(); // setFormTextValue(Transproperitem); // this.Close(); break; case "ZDProperty_Color": (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.R = Convert.ToSingle(R.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.G = Convert.ToSingle(G.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.B = Convert.ToSingle(B.Text); (Proinstance.Properties[EditedPropertise] as ZDProperty_Color).Value.A = Convert.ToSingle(A.Text); // var Colorproperitem = (Member + "," + EditedPropertise + "," + R.Text + "," + G.Text + "," + B.Text + "," + A.Text).ToString(); // setFormTextValue(Colorproperitem); // this.Close(); break; default: break; } } }